home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Assistant
/
Business Assistant.iso
/
dayo
/
dayorpt2
/
dayord.exe
/
DAYORPT.DOC
< prev
next >
Wrap
Text File
|
1991-06-18
|
446KB
|
5,654 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ║
║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
║ ║
║ ║
║ ║
║ ║
║ ▄██▄ █▄ ▄█░ ▄█▄ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄ ║
║ █░ ██▄██░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ ║
║ █░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░ ║
║ ▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄ ║
║ █░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░║
║ ▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀ ║
║ ║
║ ║
║ ║
║ ║
║ SMART REPORTS FOR THE DAYO MODULES ║
║ ║
║ ║
║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║
║ ║
║ ║
║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║
║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║
║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║
║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║
║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║
║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║
║ ▀▓▓▓▀ & LAN █████■████▌ O A ║
║ Applications ▐███████████ N R ║
║ ┌─┐ ┌─┐ ███████████▌ S E ║
║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║
║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║
║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║
║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║
║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║
║ █ G ║
║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB
"Try before you buy..."
┌─────────┐
┌─────┴───┐ │ (tm)
──│ │o │──────────────────
│ ┌─────┴╨──┐ │ Association of
│ │ │─┘ Shareware
└───│ o │ Professionals
──────│ ║ │────────────────────
└────╨────┘ MEMBER
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware principle
works for you. If you are unable to resolve a shareware-related problem with
an ASP member by contacting the member directly, ASP may be able to help.
The ASP Ombudsman can help you resolve a dispute or problem with an ASP
member, but does not provide technical support for members' products. Please
write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI 49442-9427 or
send a Compuserve message via easyplex to ASP Ombudsman 70007,3536
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered DAYO products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 1 year after
date of registration or upgrade.
3. Support is available through the following methods:
- Phone/Voice Mail: (407) 291-3960/6987
- U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
DAYO Smart Reports, TJS LAB
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
1......INTRODUCTION
2......COPYRIGHT/LICENSE
2......DISCLAIMER
2......REQUIREMENTS ***
2......SETUP
3......PASSWORD/NAME
4......MAIN MENU
4......REPORTS/ROUTINES LIST
5......SINGLE WAREHOUSE REPORT
6......VALUATION EXPANDED REPORT
8......REORDER REPORT - 2, 4, OR 8 WEEKS AVERAGE
9......STOCKLEVEL SHORTAGE REPORT
10......STOCKLEVEL OVER REPORT
11......INVENTORY ASCII TEXT
12......LATE PURCHASE ORDER REPORT
13......PURCHASE ORDER DUE IN REPORT
14......INVENTORY ZERO COST ITEMS REPORT
15......INVENTORY ZERO PRICE ITEMS REPORT
16......INVENTORY ZERO RETAIL ITEMS REPORT
17......NEGATIVE ONHAND REPORT
18......MARGIN HISTORY (AVERAGE MARGIN & COST)
19......MARGIN HISTORY (LAST 12 WEEKS)
20......VENDOR LIST
20......EXAMPLE OF THE VENDOR LIST
21......CUSTOMER LIST
21......EXAMPLE OF THE CUSTOMER LIST
22......INVENTORY ITEM LIST
22......EXAMPLE OF THE INVENTORY ITEM LIST
23......CHECKING ACCOUNT LIST
23......EXAMPLE OF THE CHECKING ACCOUNT LIST
24......CHECK FORMAT LIST
24......EXAMPLE OF THE CHECKING ACCOUNT FORMATS LIST
25......EXPENSES LIST
25......EXAMPLE OF THE EXPENSES LIST
26......WAREHOUSE ADJUSTMENTS REPORT
26......EXAMPLE OF THE WAREHOUSE ADJUSTMENTS REPORT
27......HP LASER PULL SHEET/REPORT WITH FILTER
29......INVENTORY EXPANDED REPORT WITH FILTER
30......INVENTORY AVAILABLE REPORT WITH FILTER
31......CHECK FOR DUPLICATE RECORDS/INDEX KEYS
31......EXAMPLE OF THE DUPLICATE RECORD/INDEX KEY REPORT
32......GL POSTING PROBLEMS
32......EXAMPLE OF GL POSTING PROBLEMS REPORT
33......TAX SUMMARIES
34......MASTER INVENTORY
34......EXAMPLE OF THE MASTER INVENTORY UPDATE REPORT
35......NON-TAXABLE SALES
36......BIG LABELS
36......BIG LABELS CONFIGURATION
DAYO Smart Reports, TJS LAB
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
37......CUSTOMER EXPANDED
38......AP ADJUSTMENTS
38......BATCH INVENTORY ADJUSTMENTS
39......AR ADJUSTMENTS
40......SPECIAL SALES REPORT I
41......SPECIAL SALES REPORT II
43......SPECIAL SALES REPORT III
44......CUSTOMER LIST #2
45......EXAMPLE OF THE CUSTOMER LIST #2
46......INSERT DECIMALS
47......WAREHOUSE REORDER
48......SERIAL NUMBERS IN
49......EXAMPLE OF THE SERIAL NUMBER IN REPORT
49......SERIAL NUMBERS OUT
49......EXAMPLE OF THE SERIAL NUMBER OUT REPORT
50......BAD RECORDS
51......RESET ALLOCATED
52......RESET BO - BACK ORDER QUANTITY
53......SET MULTIPLE PRICE FIELDS IN INVENTORY
54......MULTIPLE PRICING PROGRESS GRAPH
55......MODIFY SCREEN COLORS
55......COLOR CHART
58......ITEM TRACKER
61......AR DISCREPANCIES
62......EXAMPLE OF AR BUG REPORT
63......AP DISCREPANCIES
64......EXAMPLE OF AP BUG REPORT
65......RENTAL REPORT, RENTALS OUT
66......CHANGE ITEM NUMBER
68......CREDIT CARDS & CHECKS
69......INVENTORY PRICES
70......SALES COMMISSION REPORT
70.1....DAILY 'DOLLAR' (AR RECEIPTS) REPORT
70.1....JEWELRY TAGS - INVENTORY PRICE TAGS
70.2....INVOICE DETAIL HISTORY REPORT
71......VIEW REPORTS ON SCREEN
72......REPORT VIEWING SCREEN
73......PRINTER DRIVER (SETUP)
73......PRINTER DRIVER OPTIONS
74......CHANGE DEFAULT PRINTER
75......FULL SCREEN EDIT - F2
75......PRINTER DRIVER DATABASE FIELD DEFINITIONS
76......CONFIGURATION
76......CONFIGURATION LISTING
77......COMPANY NAME, ADDRESS & TELEPHONE
77......INVENTORY LOCATION/DIRECTORY
77......POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY
78......CUSTOMER DATABASE LOCATION/DIRECTORY
78......ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY
DAYO Smart Reports, TJS LAB
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
78......QUOTES DATABASE LOCATION/DIRECTORY
79......BACKORDERS DATABASE LOCATION/DIRECTORY
79......PRICE BOOK DATABASE LOCATION/DIRECTORY
79......REPORT PRINTER TYPE
79......REPORT PRINTER PORT
80......MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE
80......COLOR MONITOR
80......COLOR INTENSITY
81......MISCELLANEOUS ROUTINES
81......MISC ROUTINES MENU:
82......APPEND FROM
84......BROWSE DATABASES
86......COPY (.DBF) TO
88......CREATE DATABASE
90......DELETE RECORDS
91......ERASE FILE
91......EXIT TO DOS
92......INDEX A DATABASE
93......LIST FIELDS
96......MODIFY DATABASE
97......PACK DATABASE
98......RECALL RECORDS
98......RETURN TO MENU
98......RUN (DOS COMMAND)
99......SIMPLE EDITOR
100......SORT DATABASE
101......TYPE (PRINT) FILE
102......ZAP DATABASE
104......HELP SCREENS
105......EXPANDED HELP
106......USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
107......VIEW DOCUMENTATION ONSCREEN
108......DAYO SMART REPORTS MAINTENANCE & QUIRKS
109......TJS 'Computer' LAB
DAYO Smart Reports, TJS LAB Page: 1
■ INTRODUCTION
DAYO Smart Reports contains a collection of miscellaneous reports and
routines that many other software packages leave out. Some of the DAYO Smart
Reports actually write to your databases (ie: the calculating of the
STOCKLEVEL field in the database INV.DBF). Smart Reports should be run
periodically to 'check up on' or comfirm the accuracy of your data.
There are 60+ Reports/Lists/Routines included in Smart Reports:
Single Warehouse Expenses List
Valuation Expanded Warehouse Adjustments
ReOrder (2 weeks) HP Laser Pull Sheet
ReOrder (4 weeks) Inventory Expanded
ReOrder (8 weeks) Available Inventory
StockLevel Shortage Duplicate Records
StockLevel Over View Reports on Screen
Inventory ASCII Text Master Inventory Update
Late PO Tax Summaries
PO - Due In This Week Non-Taxable Sales
Inventory Zero Cost Customer Expanded
Inventory Zero Price AP Adjustments
Inventory Zero Retail Batch Inventory Adjustments
Negative Onhand AR Adjustments
Printer Setup Special Sales Report #1
GL Posting Problems Special Sales Report #2
Big Labels Special Sales Report #3
Margin (History) Customer List #2
Margin (12 Weeks) Insert Decimals
Vendor List Warehouse ReOrder
Customer List Serial Numbers In
Inventory Item List Serial Numbers Out
Checking Account List Bad Records
Check Format List Modify Screen Colors
Rentals Item Tracker *
Set/Reset Prices Credit Cards & Checks
AR Discrepancies Inventory Prices
AP Discrepancies Sales Commission
Change ITEM Number Daily Dollar Report
Invoice Detail History
DAYO Smart Reports is by default a multiuser system.
Other DAYO Products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO POS Point of Sales Billing & Invoicing
DAYO AR Accounts Receivable
DAYO AP Accounts Payable
DAYOX Network/LAN Index Maintenance Utility
& many more...
DAYO Smart Reports, TJS LAB Page: 2
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. An exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to DAYO Smart Reports software,
documentation, and source codes.
Read the Order Form (last page), for more information on Source Codes...
Authorization to distribute the Shareware Version (unregistered) is
granted.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware
and/or software systems as a result of using DAYO Smart Reports.
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
■ SETUP
To setup DAYO Smart Reports, copy the contents of the DAYO Smart Reports
floppy disk into a directory on your hard disk (ie: \DAYORPT). If this is
the Shareware Version, you need to UnZip/UnArc the files. When you run
DAYO Smart Reports for the first time, it will create all the database,
index, and configuration files it requires for operation. If you are using
other DAYO modules, be sure to enter the location of these databases into
the DAYO Smart Reports configuration. Type and enter 'DAYOR' at the DOS
prompt to run the program (ie: C:\DAYOR ).
*** Your CONFIG.SYS file must have the buffers set to a minimun of 10, and
your files must have a minimun setting of 55! Failure to edit the CONFIG.SYS
file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is
created if there is a problem detected, in the directory that this DAYO
module is being run in. You may copy this file into your root/boot drive.
Refer to your DOS manual for more information on the CONFIG.SYS file!
DAYO Smart Reports, TJS LAB Page: 3
■ PASSWORD/NAME
The first prompt you get when you enter DAYO Reports is the one for you
to enter your name (or password if using DAYO Passwords):
DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐
Copyright (c) 1989-1991, All Rights Reserved │S M T W T F S │
╔════════════════════════╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
║ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
║ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
║ DAYO ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │
║ Smart ║ │ │
║ Reports ║ └────────────────────┘
║ ╠══════════════════════════════════════════════════╗
║ ║ ║
┌────────────────────────────────────────────────────────────────────────────┐
│┌──────────────────────────────────────────────────────────────────────────┐│
││ Enter Your Name: George Moonilal ││
│└──────────────────────────────────────────────────────────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
╚════════════════════════╩══════════════════════════════════════════════════╝
▄██▄ █▄ ▄█░ ▄█▄ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄
█░ ██▄██░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░
█░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░
▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄
█░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░
▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀
DAYO Smart Reports, TJS LAB Page: 4
■ MAIN MENU
After a few moments and possibly a reindex, the main menu will appear
(the left side of the screen is the actual main menu):
DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐
Copyright (c) 1989-1991, All Rights Reserved │S M T W T F S │
╔════════════════════════╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
║Configuration ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
║Single Warehouse ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
║Valuation Expanded ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
║ReOrder (2 weeks) ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
║ReOrder (4 weeks) ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │
║ReOrder (8 weeks) ║ │ │
║StockLevel Shortage ║ └────────────────────┘
║StockLevel Over ╠═[ Configuration ]═════════════════════════════════╗
║Inventory ASCII Text ║ ║
║Late PO ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║
║PO - Due In This Week ║ DAYO Reports Configuration Settings. ║
║Inventory Zero Cost ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║
╠════════════════════════╣ ║
║ Press Esc to Exit ║ ║
╚════════════════════════╩═══════════════════════════════════════════════════╝
▄██▄ █▄ ▄█░ ▄█▄ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄
█░ ██▄██░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░
█░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░
▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄
█░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░
▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀
Report 1 of 31
Note that this DAYO Module has a different Main Menu. With the exception
of the CONFIGURATION and MISC ROUTINES menu options, all other options listed
on the DAYO Smart Reports menu are reports.
DAYO Smart Reports, TJS LAB Page: 5
■ SINGLE WAREHOUSE REPORT
The Single Warehouse Report prints cost information about each item in a
specific warehouse (found in the WAREHOUS.DBF). This report also includes the
valuation of each item (cost * quantity). This report is 'hard coded'; not a
report form.
The following fields/variables are printed:
Item
VendItem
Description
Cost
Price
Main Inventory Stock Level
LOCxxx (Warehouse Quantity)
SLLOCxxx (Stocking Level for this Warehouse Item)
ReOrder
Valuation
╔═[ Single Warehouse ]═══════════════════════════════╗
║ ║
║ Single Expanded Inventory Warehouse Report. ║
║ Not a Report Form. ║
║ Uses Databases: INV.DBF, WAREHOUS.DBF, ║
║ & WARENAME.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Single Warehouse ]═══════════════════════════════╗
║ ║
║ Enter Location: LOC 1 ║
║ Include 'Ok' Items? (Y/N) ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: SINGLE.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 6
■ VALUATION EXPANDED REPORT
The Valuation Expanded Report is essentially the same as the Inventory
Expanded report except that the Valuation is included. A dBase (tm)
compatible report form is required (VALUATIO.FRM).
The following fields/variables are included on this report:
ITEM ONORDER VALUATION
VENDOR ITEM COST TYPE
DESCRIPTION RETAIL CLASS
ONHAND PRICE
The first prompt is to select the index (order of the report):
╔══════════════════════════════════════════════════════╗
║The Default Valuation Inventory Report (VALUATIO.FRM) ║
║contains the following fields/variables: ║
║ ITEM COST ║
║ DESC RETAIL ║
║ ONHAND PRICE ║
║ ONORDER TYPE ║
║ VENDITEM CLASS ║
║ VALUATION ║
║ ║
║Select the Index -> ITEM (ITEM) ║
║ DESCRIPTION (DESC) ║
║ VENDOR CODE (VENDOR) ║
║ VENDOR ITEM (VENDITEM) ║
║ TYPE (TYPE) ║
║ ║
║ ║
║ ║
║ ║
╚══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 7
The second prompt is for a 'filter' or condition. The filter must/can be
any valid dBase (tm) expression. To include all records (no filter), just
press enter on an empty (blank) prompt...
╔══════════════════════════════════════════════════════╗
║The Default Valuation Inventory Report (VALUATIO.FRM) ║
║contains the following fields/variables: ║
║ ITEM COST ║
║ DESC RETAIL ║
║ ONHAND PRICE ║
║ ONORDER TYPE ║
║ VENDITEM CLASS ║
║ VALUATION ║
║ ║
║Select the Index -> ITEM (ITEM) ║
║ ║
║Enter Filter: PRICE>100.00 ║
║EG: TYPE = "XXX" ║
║ ║
║Enter Heading: TJS LAB ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: VALUE.TXT ║
║ ║
╚══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 8
■ REORDER REPORT - 2, 4, OR 8 WEEKS AVERAGE
This ReOrder Report calculates and optionally resets the STOCKLEVEL
field in the database INV.DBF based on sales data (from the DAYO POS
database DETAIL.DBF). You select the number of weeks stockage (2, 4, or
8 weeks).
This report does not utilize a report form.
The following fields/variables are included on this report:
ITEM STOCKLEVEL REORDER
VENDOR ITEM COST EXTENDED COST
DESCRIPTION RETAIL CLASS
ONHAND PRICE TYPE
╔═[ ReOrder (2 weeks) ]══════════════════════════════╗
║ ║
║ ReOrder Based On Last 2 Weeks Sales. ║
║ Not a Report Form. ║
║ Uses Databases: INV.DBF, DETAIL.DBF. ║
║ Optionally Resets the StockLevel Field. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ ReOrder (8 weeks) ]══════════════════════════════╗
║ ║
║ Reset the StockLevel Field? (Y/N) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: REORDER8.TXT ║
╚════════════════════════════════════════════════════╝
The progress of the reorder report is display with a graph...
0 Records 2 3
╔════════════════╦══════════════════╦═════════════════╦════════════════╗
╠███████████████████████════════════╬═════════════════╬════════════════╣
╠════════════════╩══════════════════╬═════════════════╩════════════════╣
0% Completed 50% Done!
DAYO Smart Reports, TJS LAB Page: 9
■ STOCKLEVEL SHORTAGE REPORT
The StockLevel Shortage Report will alert you to any item that falls
below the stockage level in the main inventory database INV.DBF. The
algorithm/formula is to report all items when ONHAND is less than the
STOCKLEVEL.
This report does use a report form (INVSTOCK.FRM), and it is highly
recommended that you modify it (with dBase III+/IV), if you want to use your
other warehouses (WAREHOUS.DBF), in the calculation.
The following fields/variables are included on this report:
ITEM ONHAND RETAIL
VENDITEM LEVEL PRICE
DESC ONORDER TYPE
VENDOR COST
╔═[ StockLevel Shortage ]════════════════════════════╗
║ ║
║ StockLevel Shortage Report. ║
║ Reports ONHAND < STOCKLEVEL. ║
║ Uses a Report Form: INVSTOCK.FRM. ║
║ Uses Database: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ StockLevel Shortage ]════════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: INVSHORT.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 10
■ STOCKLEVEL OVER REPORT
The StockLevel Over Report will alert you to any item that is excess
in the main inventory database INV.DBF. The algorithm/formula is to report
all items when ONHAND is greater than the STOCKLEVEL.
This report does use a report form (INVSTOCK.FRM), and it is highly
recommended that you modify it (with dBase III+/IV), if you want to use your
other warehouses (WAREHOUS.DBF), in the calculation.
The following fields/variables are included on the STOCK OVER report:
ITEM ONHAND RETAIL
VENDITEM LEVEL PRICE
DESC ONORDER TYPE
VENDOR COST
╔═[ StockLevel Over ]════════════════════════════════╗
║ ║
║ StockLevel Over Report. ║
║ Reports ONHAND > STOCKLEVEL. ║
║ Uses a Report Form: INVSTOCK.FRM. ║
║ Uses Database: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ StockLevel Over ]════════════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: INVOVER.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 11
■ INVENTORY ASCII TEXT
If there exists a need to import inventory fields into a word processor
or editor, you can use this report to create an ASCII/text file in the
Standard Data Format (SDF). This format is often called a flat file. Other
'flat' files/reports can be created with the LIST option in the MISC
ROUTINES.
The format for the file is:
Field Len Start Stop
----------- --- ----- ----
ITEM 12 1 12
VENDITEM 12 13 24
DESC 30 25 54
VENDOR 10 55 64
ONHAND 7 65 71
COST 10 72 81
PRICE 10 82 91
RETAIL 10 92 101
STOCKLEVEL 7 102 108
TYPE 3 109 111
CLASS 3 112 114
╔═[ Inventory ASCII Text ]═══════════════════════════╗
║ ║
║ Inventory ASCII Text File. ║
║ Creates an ASCII text file for ║
║ import into a work processor or ║
║ spreadsheet. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Inventory ASCII Text ]═══════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Enter File Name: INVASCII.TXT ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 12
■ LATE PURCHASE ORDER REPORT
This report simply reports any purchase order that is overdue to be
received. This report will only work if the ETA (Estimate time [date]),
field in the database POH.DBF (Purchase Order Headers), is maintain.
A report form is used (LATEPO.FRM).
Fields/variables in the report:
PO DESC DATE (of PO)
VENDOR ORDERED ETA
ITEM RECEIVED LATE (Number of days overdue)
VENDITEM DUE (Amount due in)
╔═[ Late PO ]════════════════════════════════════════╗
║ ║
║ Late Purchase Order Report. ║
║ Reports Date > ETA. ║
║ Uses a Report Form: LATEPO.FRM. ║
║ Uses Databases: POD.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Late PO ]════════════════════════════════════════╗
║ ║
║ Select the Index -> ITEM ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: LATEPO.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 13
■ PURCHASE ORDER DUE IN REPORT
This report will give you advance notice of the due dates/arrival of
product from your vendors. This report requires the maintenance of the ETA
field in the database POH.DBF (Purchase Order Headers).
Fields/variables in the report:
PO DESC DATE (of PO)
VENDOR ORDERED ETA
ITEM RECEIVED DUE (Number of days overdue)
VENDITEM DUE (Amount due in)
╔═[ PO - Due In This Week ]══════════════════════════╗
║ ║
║ PO - Due In This Week Report. ║
║ Reports Purchase Orders Due to be received within ║
║ the next 7 days. ║
║ Uses Report Form: PODUEIN.FRM. ║
║ Uses Databases: POH.DBF & POD.DBF. ║
╚════════════════════════════════════════════════════╝
╔═[ PO - Due In This Week ]══════════════════════════╗
║ ║
║ Select the Index -> PO ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: PODUEIN.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 14
■ INVENTORY ZERO COST ITEMS REPORT
This Smart Report will report only items with a cost less than or equal
to zero. Use this report to insure you have no items listed in your
inventory database without a cost value.
The report form ZEROCOST.FRM is utilized.
The following fields/variables are included in the report:
ITEM ONHAND PRICE
VENDITEM ONORDER TYPE
DESC COST CLASS
VENDOR RETAIL
╔═[ Inventory Zero Cost ]════════════════════════════╗
║ ║
║ Inventory Zero Cost Items Report. ║
║ Reports any inventory item with a COST <= 0. ║
║ Uses a Report Form: ZEROCOST.FRM. ║
║ Uses Databases: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Inventory Zero Cost ]════════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: 0COST.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 15
■ INVENTORY ZERO PRICE ITEMS REPORT
This Smart Report will report only items with a price less than or equal
to zero. Use this report to insure you have no items listed in your
inventory database without a price value.
The report form ZEROCOST.FRM is utilized.
The following fields/variables are included in the report:
ITEM ONHAND PRICE
VENDITEM ONORDER TYPE
DESC COST CLASS
VENDOR RETAIL
╔═[ Inventory Zero Price ]═══════════════════════════╗
║ ║
║ Inventory Zero Price Items Report. ║
║ Reports any inventory item with a PRICE <= 0. ║
║ Uses a Report Form: ZEROCOST.FRM. ║
║ Uses Databases: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Inventory Zero Price ]═══════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: 0PRICE.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 16
■ INVENTORY ZERO RETAIL ITEMS REPORT
This Smart Report will report only items with a retail/list 'price'
less than or equal to zero. Use this report to insure you have no items
listed in your inventory database without a retail/list value.
The report form ZEROCOST.FRM is utilized.
The following fields/variables are included in the report:
ITEM ONHAND PRICE
VENDITEM ONORDER TYPE
DESC COST CLASS
VENDOR RETAIL
╔═[ Inventory Zero Retail ]══════════════════════════╗
║ ║
║ Inventory Zero Retail Items Report. ║
║ Reports any inventory item with a RETAIL <= 0. ║
║ Uses a Report Form: ZEROCOST.FRM. ║
║ Uses Databases: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Inventory Zero Retail ]══════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: 0RETAIL.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 17
■ NEGATIVE ONHAND REPORT
This report will alert you to a posting problem (probably with DAYO
POS). It is not recommended that invoices be created without items in the
inventory database (INV.DBF), however it is an optional DAYO Inventory
configuration setting to allow/disallow it.
The report form NEGQTY.FRM is utilized.
The following fields/variables are included in the report:
ITEM ONHAND PRICE
VENDITEM ONORDER TYPE
DESC COST CLASS
VENDOR RETAIL
╔═[ Negative Onhand ]════════════════════════════════╗
║ ║
║ Inventory Negative Onhand Report. ║
║ Reports any inventory item with an ONHAND < 0. ║
║ Uses a Report Form: NEGQTY.FRM. ║
║ Uses Databases: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Negative Onhand ]════════════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: NEGQTY.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 18
■ MARGIN HISTORY (AVERAGE MARGIN & COST)
Use this report on the occasions that you need to know the average
margin for your inventory items based on the total sales history. The
average cost is also calculated. Knowing these values is often necessary in
determining the PRICE.
No report form is utilized.
The following fields/variables are included in the report:
ITEM PRICE
VENDITEM RETAIL
DESC AVERAGE COST
COST MARGIN
╔═[ Margin (History) ]═══════════════════════════════╗
║ ║
║ Item Average Margin (All Sales History). ║
║ Report of the average sales margin for an item. ║
║ Uses a Report Form: AMARGIN.FRM. ║
║ Uses Databases: INV.DBF & DETAIL.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Margin (History) ]═══════════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: AMARGIN.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 19
■ MARGIN HISTORY (LAST 12 WEEKS)
Use this report on the occasions that you need to know the average
margin for your inventory items based on the last 12 weeks of sales history.
The average cost is also calculated. Knowing these values is often necessary
in determining the PRICE.
No report form is utilized.
The following fields/variables are included in the report:
ITEM PRICE
VENDITEM RETAIL
DESC AVERAGE COST
COST MARGIN
╔═[ Margin (12 Weeks) ]══════════════════════════════╗
║ ║
║ Item Average Margin (Last 12 Weeks History). ║
║ Report of the average sales margin for an item ║
║ using the last 12 weeks of sales data. ║
║ Uses a Report Form: AMARGIN.FRM. ║
║ Uses Databases: INV.DBF & DETAIL.DBF. ║
╚════════════════════════════════════════════════════╝
╔═[ Margin (12 Weeks) ]══════════════════════════════╗
║ ║
║ Select the Index -> ITEM (ITEM) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: AMARGIN.TXT ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 20
■ VENDOR LIST
This is a simple listing of your vendors.
Uses the report form VENDLIST.FRM.
The following fields/variables are included in the report:
VENDOR NAME DATE PHONE
╔═[ Vendor List ]════════════════════════════════════╗
║ ║
║ Vendor List. ║
║ ║
║ Uses a Report Form: VENDLIST.FRM. ║
║ Uses Database: VENDORS.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Vendor List ]════════════════════════════════════╗
║ ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: VENDLIST.TXT ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE VENDOR LIST
Page No. 1
07/27/90
Vendors Listing
Vendor Last
Number Vendor Name Date Phone
---------- ------------------------------ -------- --------------
3M 3M TAPES 07/03/90 24 ____
6MM 6M MAINTENANCE CO 07/03/90 24 ____
ABC AL'S BEVERAGE COMPANY 07/03/90 24 ____
RDD RESEACH DEV. DIST. CENTER 07/03/90 24 ____
ROC REPUBLIC OF CHINA 07/03/90 24 ____
SSS SIERRA SUPPLY & SERVICES 07/03/90 24 ____
TLJ TJS LAB 07/03/90 24 ____
DAYO Smart Reports, TJS LAB Page: 21
■ CUSTOMER LIST
This is a simple listing of your customers.
Uses the report form CUSTLIST.FRM.
The following fields/variables are included in the report:
CUSTOMER NAME PHONE
╔═[ Customer List ]══════════════════════════════════╗
║ ║
║ Customer List. ║
║ ║
║ Uses a Report Form: CUSTLIST.FRM. ║
║ Uses Database: VENDORS.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Customer List ]══════════════════════════════════╗
║ ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: CUSTLIST.TXT ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE CUSTOMER LIST
Page No. 1
07/27/90
Customer List
Customer Name Phone
-------- ------------------------------ --------------
301210 DASHER, DON 744-4541 _____________
301211 DASHLEY COURT _____________
301212 MRS. BERT _____________
301213 KALUMINEX 743-8634 _____________
301214 ADVANCED ELECTRONICS _____________
301215 DENNYS CONSTRUCTION 740-6741 _____________
301216 BARKALOW, ROB 846-4169 _____________
301218 BURGER KING 744-3332 _____________
301219 MALLO CONSTRUCTION CO _____________
DAYO Smart Reports, TJS LAB Page: 22
■ INVENTORY ITEM LIST
This is a listing of your inventory items.
Uses the report form ITEMLIST.FRM.
The following fields/variables are included in the report:
ITEM VENDITEM DESC
╔═[ Inventory Item List ]════════════════════════════╗
║ ║
║ Inventory Item List. ║
║ ║
║ Uses a Report Form: ITEMLIST.FRM. ║
║ Uses Database: INV.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Inventory Item List ]════════════════════════════╗
║ ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: ITEMLIST.TXT ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE INVENTORY ITEM LIST
Page No. 1
07/27/90
INVENTORY ITEM LISTING
Vendor or
Item Mfg Item Description
------------ ------------ ------------------------------
2" GUTTER 2" GUTTER SYSTEM _____________
2ALM518 2" ALMOND COIL _____________
2ALM519 2" ALMOND COIL _____________
2ALM527 2" ALMOND COIL _____________
2ALM533 2" ALMOND COIL _____________
2ANT123 2" ANT IVORY COIL _____________
2ANT143 2" ANT IVORY COIL _____________
2ANT148 2" ANT IVORY COIL _____________
DAYO Smart Reports, TJS LAB Page: 23
■ CHECKING ACCOUNT LIST
This is a listing of your inventory items.
Uses the report form ACCTLIST.FRM.
The following fields/variables are included in the report:
NUMBER ACCTNUM NAME BALANCE
╔═[ Checking Account List ]══════════════════════════╗
║ ║
║ Checking Account List. ║
║ ║
║ Uses a Report Form: ACCTLIST.FRM. ║
║ Uses Database: ACCOUNTS.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Checking Account List ]══════════════════════════╗
║ ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: ACCTLIST.TXT ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE CHECKING ACCOUNT LIST
Page No. 1
07/27/90
CHECKING ACCOUNTS LISTING
Account
Number Number Bank/Account Name Balance
------ -------------------- ------------------------------ ----------
1 0100983-28838-20 C&S National Bank, Orlando 12980.17
2 12321-1232-XA CAPONES Private Bank 15.00
*** Total ***
12995.12
DAYO Smart Reports, TJS LAB Page: 24
■ CHECK FORMAT LIST
This is a listing of all your check formats (the printer settings for
the printing of special/custom checks). Only the length and width of the
check form is printed...
Uses the report form CHKFLIST.FRM.
The following fields/variables are included in the report:
FORMAT NAME CHECK LENGTH CHECK WIDTH
╔═[ Check Format List ]══════════════════════════════╗
║ ║
║ Check Format List of all your 'Unique' ║
║ Check Formats. ║
║ Uses a Report Form: CHKFLIST.FRM. ║
║ Uses Database: CFORMAT.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Check Format List ]══════════════════════════════╗
║ ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: CHKFLIST.TXT ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE CHECKING ACCOUNT FORMATS LIST
Page No. 1
07/27/90
CHECKING ACCOUNT FORMATS LIST
Check Check
Format Name Length Width
------ ------------------------------ ------ -----
1 Nebb's Radio Shack Check Type 41 80 __________________
2 Moore Check # 1929 21 80 __________________
3 Computer Forms, Inc #93001-A 19 90 __________________
DAYO Smart Reports, TJS LAB Page: 25
■ EXPENSES LIST
This is a listing of all your expenses.
Uses the report form EXPLIST.FRM.
The following fields/variables are included in the report:
WHATFOR NUMBER AMOUNT DATE
╔═[ Expenses List ]══════════════════════════════════╗
║ ║
║ Expenses List of all your 'Unique' Expenses. ║
║ ║
║ Uses a Report Form: EXPLIST.FRM. ║
║ Uses Database: EXPENSES.DBF. ║
║ ║
╚════════════════════════════════════════════════════╝
╔═[ Expenses List ]══════════════════════════════════╗
║ ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ ║
║ Enter File Name: EXPLIST.TXT ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE EXPENSES LIST
Page No. 1
07/27/90
EXPENSES LIST
Expense
Expense For... Number Amount Date
---------------------------------------- ------- ---------- --------
Red Bug Exterminators 120 45.00 12/04/89 _______
South Carolina Electric & Gas 121 1245.31 01/17/90 _______
Carleton Cars 122 530.40 01/12/90 _______
Joe's Lawn Service 123 15.00 02/23/90 _______
Mary Martin & Associates 144 50.00 04/14/90 _______
*** Total ***
1885.71
DAYO Smart Reports, TJS LAB Page: 26
■ WAREHOUSE ADJUSTMENTS REPORT
This report list all inventory adjusts for a selected data range that
are warehouse related.
Uses the report form WAREADJ.FRM
╔═[ Warehouse Adjustments ]══════════════════════════╗
║■Start Date: 01/27/90 Ending Date: 07/27/90 ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: WAREADJ.TXT ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE WAREHOUSE ADJUSTMENTS REPORT
Page No. 1
07/27/90
WAREHOUSE ADJUSTMENTS REPORT
Ware- Reason Extended
House For Item Description Qty Cost Date
------- --------------- ------------ --------------- ------ ---------- -----
** Warehouse: LOC1
1 Found in the JAR-1 3 4.23 12/89
receiving area JAR #1, 30
1 Found in the JAR-2 1 1.00 12/89
receiving area JAR #2, 10-A
1 Returned JAR-3 1 1.00 12/89
JAR #3
** Subtotal **
5 6.23
3 Found in the JAR-3 1 1.00 12/89
shipping area JAR #3
** Subtotal **
1 1.00
*** Total ***
6 7.23
DAYO Smart Reports, TJS LAB Page: 27
■ HP LASER PULL SHEET/REPORT WITH FILTER
This report will ONLY print onto an HP Laser or a compatible printer!
The first prompt is for a 'filter' or condition. The filter must/can be
any valid dBase (tm) expression. To include all records (no filter), just
press enter on an empty (blank) prompt...
╔═[ HP Laser Pull Sheet ]════════════════════════════╗
║■ ║
║ EG: TYPE='XXX' ║
║ Enter Filter: TYPE="ABC" ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
The Pull Sheet can be printed without any prices, the cost, price, or
the retail (list) price...
╔═[ HP Laser Pull Sheet ]════════════════════════════╗
║■Select Pull Sheet -> Pull Sheet - No Costs/Prices ║
║ Pull Sheet - Cost ║
║ Pull Sheet - Price ║
║ Pull Sheet - Retail/List ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
There exists 8 index options for the Pull Report:
1. Item Number
2. Item Description
3. Vendor Number
4. Vendor/Mfg Item Number
5. Item Type
6. Item CLASS Code
7. Item Cost
8. Location + Item Number
╔═[ HP Laser Pull Sheet ]════════════════════════════╗
║■Select Pull Sheet ->Pull Sheet - No Costs/Prices ║
║ Select Index -> Item Number ║
║ Item Description ║
║ Use the down Vendor Number ║
║ arrow key to Vendor/Mfg Item Number ║
║ view more... Item Type ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 28
The last 3 index options (CLASS, COST, or LOCATION) require the creation
of a temporary index, ie:
┌──────────────────────────────────────────────────────────┐
│ Database Name: \DAYOINV\INV.DBF │
│ Index Name: TEMP51.NTX │
│ Number of Records: 303 │
│ ┌──────────────────────────────────────────────────┐ │
│ │██████████████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
The Pull Sheet can be directed to the printer or to a file (for later
printing. Note, this report CAN NOT be viewed onscreen because of the laser
printer codes...
╔═[ HP Laser Pull Sheet ]════════════════════════════╗
║■Select Pull Sheet ->Pull Sheet - No Costs/Prices ║
║ Select Index ->Item CLASS Code ║
║ Send Output to Printer? (Y/N) ║
║ (Remember, only HP Laser or Compatible) ║
║ Enter File Name: PULL.TXT ║
║ ║
╚════════════════════════════════════════════════════╝
A progress graph is displayed while the report is generated:
╔═[ HP Laser Pull Sheet ]════════════════════════════╗
║■Select Pull Sheet ->Pull Sheet - No Costs/Prices ║
║ Select Index ->Item Cost ║
║ Send Output to Printer? (Y/N) ║
║ (Remember, only HP Laser or Compatible) ║
║ ├███████─┬──┬──┬──┬──┬──┼──┬──┬──┬──┬──┬──┬──┬──┤ ║
║ % 50% finis ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 29
■ INVENTORY EXPANDED REPORT WITH FILTER
The first prompt for the Expanded Inventory is for the index (order of
the report):
╔═[ Expanded Inventory Report ]════════════════════════╗
║The Default Expanded Inventory Report (EXPANDED.FRM) ║
║contains the following fields/variables: ║
║ ITEM COST ║
║ DESC RETAIL ║
║ ONHAND PRICE ║
║ ONORDER TYPE ║
║ VENDITEM CLASS ║
║ VENDOR ║
║ ║
║Select the Index -> ITEM (ITEM) ║
║ DESCRIPTION (DESC) ║
║ VENDOR CODE (VENDOR) ║
║ VENDOR ITEM (VENDITEM) ║
║ TYPE (TYPE) ║
║ ║
║ ║
║ ║
║ ║
╚══════════════════════════════════════════════════════╝
The second prompt is for a 'filter' or condition. The filter must/can be
any valid dBase (tm) expression. To include all records (no filter), just
press enter on an empty (blank) prompt...
╔═[ Expanded Inventory Report ]════════════════════════╗
║The Default Expanded Inventory Report (EXPANDED.FRM) ║
║contains the following fields/variables: ║
║ ITEM COST ║
║ DESC RETAIL ║
║ ONHAND PRICE ║
║ ONORDER TYPE ║
║ VENDITEM CLASS ║
║ VENDOR ║
║ ║
║Select the Index -> ITEM (ITEM) ║
║ ║
║Enter Filter: CLASS=" " ║
║EG: TYPE = "XXX" ║
║ ║
║Include Zero (0) Cost Items? (Y/N) ║
║Enter Heading: EXPANDED REPORT ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: EXPANDED.TXT ║
╚══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 30
■ INVENTORY AVAILABLE REPORT WITH FILTER
This report is identical to the Expanded Inventory Report except that
it only reports items with an ONHAND quantity not equal to Zero (0).
╔═[ Available Inventory Report ]═══════════════════════╗
║The Available Report only prints items with an ONHAND ║
║not equal to zero. Otherwise the same as the Expanded.║
║ ITEM COST ║
║ DESC RETAIL ║
║ ONHAND PRICE ║
║ ONORDER TYPE ║
║ VENDITEM CLASS ║
║ VENDOR ║
║ ║
║Select the Index -> ITEM (ITEM) ║
║ ║
║Enter Filter: COST>1000 ║
║EG: TYPE = "XXX" ║
║ ║
║Include Zero (0) Cost Items? (Y/N) ║
║Enter Heading: AVAILABLE REPORT ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: AVALABLE.TXT ║
╚══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 31
■ CHECK FOR DUPLICATE RECORDS/INDEX KEYS
This report/routine is used to find duplicate records in any database
that is indexed. The prompts are for the database name (you can include the
drive/directory/path), and the index name. The routine will determine the
index key (the field that created the selected index).
If any duplicate records (index key values) are found, a report will
be generated (directed to printer or file).
╠═[ Check for Duplicates ]═══════════════════════════╗
║■ ║
║ Enter Database Name: \DAYOPOS\INVOICE ║
║ Enter Index Name: \DAYOPOS\INVOICE ║
║ Send Output to Printer? (Y/N) ║
╣ ( No -> To File) ║
║ Enter File Name: DUPES.TXT ║
╩════════════════════════════════════════════════════╝
The progress of this routine is displayed onto the screen. If any
duplicates are found, a short beep will sound...
╔════[ Duplicate Record Check ]══════════════════════════════════════╗
║ Looking for duplicate KEY fields in the following: ║
║ Database \DAYOPOS\INVOICE ║
║ Index \DAYOPOS\INVOICE ║
║ KEY INVOICE ║
║ Number of records to search: 111 ║
╟██████████████████████████████████████┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢
║0 50% Finis║
╚════════════════════════════════════════════════════════════════════╝
Standby While I Print This Report! Press Esc to Abort
■ EXAMPLE OF THE DUPLICATE RECORD/INDEX KEY REPORT
Duplicate Record Check Page 1
Database: \DAYOPOS\INVOICE
Index: \DAYOPOS\INVOICE
KEY: INVOICE
Records 6 & 7 are duplicated: 63
Records 7 & 8 are duplicated: 63
Records 20 & 21 are duplicated: 77
Records 28 & 29 are duplicated: 86
DAYO Smart Reports, TJS LAB Page: 32
■ GL POSTING PROBLEMS
This report checks databases for 'Bad' CLASS Codes that will cause a
problem at time of GL Posting.
You have the option to run it against all databases or to select
specific databases.
■ EXAMPLE OF GL POSTING PROBLEMS REPORT
Page No. 1
09/07/90
GENERAL LEDGER PRE-POST CLASS CODE
PROBLEM REPORT
DATABASE: INV.DBF
*****
CLASS Extended
Item Vendor Description CODE Date Cost*Onhand
------------ ---------- ------------------------- ***** -------- -----------
AC2320 ACSCOMMERI CHILDREN'S STRAWBERRY SAN SH 08/27/90 0.00
AC3011 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3011C ACSCOM 2-LEAF CHILD SLIPPERS SH / / 0.00
AC3019 ACSCOM DOUBLE BOWTIE LADIES SLIP SH / / 0.00
AC3111 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3211 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3311 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3411 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3511 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3611 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
AC3711 ACSCOMMERC 2-LEAF LADIES SLIPPERS SH 08/11/90 0.00
DAYO Smart Reports, TJS LAB Page: 33
■ TAX SUMMARIES
For tax reporting purposes, it is often required to summarize taxes
paid to states, and in some cases to counties. By using the TAXCODE field
in the customer's record, you can summarize taxes by unique TAXCODEs.
This is a two part report.
The first part summarizes by Ship To state, ie:
Page No. 1 Period: 01/08/90 to 09/08/90
09/08/90
DAYO TAX REPORT
SUBTOTAL BY STATE
Taxes
----------
** State Code: FL
** Subtotal **
20003.12
** State Code: CA
** Subtotal **
20.00
** State Code: SC
** Subtotal **
10.20
*** Total ***
20033.32
The second part summarizes by TAXCODE, ie:
TAX SUMMARY BY TAX CODE Date: 09/04/90
Period: 08/01/90 to 08/31/90
Code Amount
---- ----------
CX1 10.12
CX2 10.00
CX3 10.00
CX4 10.00
CX5 10.10
CX6 10.10
CXA 10.10
----------
70.42
DAYO Smart Reports, TJS LAB Page: 34
■ MASTER INVENTORY
This routine compares two DAYO inventory databases, updating one from the
the other. One database (the Master/Main Inventory) is used to update
another.
Produces a report of changes & additions.
A special feature of this report is that you can select an option to
return to DOS immediately after running the report.
■ EXAMPLE OF THE MASTER INVENTORY UPDATE REPORT
MASTER INVENTORY UPDATE - ADDITIONS & CHANGES
Date: 09/08/90 Time: 00:04:57 Page 1
Run by: SDF Site: SAL'S THINGS
ITEM DESCRIPTION MESSAGE
------------ ------------------------------ ----------
EV044K5 EVEREST BELLY BAG 5-POCKET Change
Field: CLASS Was: BB Now: CCC
SH509 PALADINO NYLON 3-PKT BELLY BAG Change
Field: WEIGHT Was: 0.00 Now: 23.00
SH709FLA FLORIDA SUPER 5-PKT BELLY BAG Change
Field: SERIALNO Was: .F. Now: .T.
MASTER INVENTORY UPDATE - ITEMS NOT IN MASTER INVENTORY * * *
Date: 09/08/90 Time: 00:05:01 Page 1
Run by: SDF Site: SAL'S THINGS
ITEM DESCRIPTION ONHAND SOLDYTD DATE
------------ ------------------------------ --------- --------- --------
AC2320 CHILDREN'S STRAWBERRY SANDAL 0.000 0.000 08/27/90
AC3011 2-LEAF LADIES SLIPPERS 0.000 0.000 08/11/90
AC3011C 2-LEAF CHILD SLIPPERS 0.000 0.000 / /
AC3019 DOUBLE BOWTIE LADIES SLIPPERS 0.000 0.000 / /
AC3211 MEN/LADIES NEON BEACHCOMBERS 0.000 0.000 / /
AC3666 SINGLE BOWTIE LADIES SLIPPERS 0.000 0.000 / /
AC3734 LADIES ELASTIC SANDAL 0.000 0.000 08/28/90
AC5201 MEN/LADIES BEACHCOMBERS 0.000 0.000 / /
DAYO Smart Reports, TJS LAB Page: 35
■ NON-TAXABLE SALES
This routine will print all taxable or non-taxable AR Header records.
This enables you to break down your sales by tax type. The report also has
the option of printing just a one line summary.
The expanded report contains the following fields:
INVOICE, CUSTOMER, TYPE, TERMS, SALESREP, CLASS, TAXRATE, TAXES,
FREIGHT, ADJUST, SUBTOTAL, PAID, BALANCE, & DATE
The summary and expanded report contains subtotals for the following
fields:
TAXES, FREIGHT, ADJUST, SUBTOTAL, PAID, & BALANCE
╔═══════════════════════════════════════════════════════╗
║This report will print all your taxable or ║
║non-taxable posted invoice headers (database ARH.DBF) ║
║or a summary for a selected date range. ║
║Uses Report Form TAXABLES.FRM (132 Character Wide) ║
║ ║
║Start Date: 08/09/90 Ending Date: 09/08/90 ║
║ ║
║Report Non-Taxable Only? (Y/N) (No: Taxable Only) ║
║ ║
║Will this be a Summary Only? (Y/N) ║
║ ║
║Select Index -> INVOICE NUMBER ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: TAX_N_X.TXT ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 36
■ BIG LABELS
This report option was added to allow you to print any size address
labels (ie: 4" X 4") for customer, shiptos, and vendors.
DAYORPT V3.0, TJS LAB ┌──[September 1990]──┐
██▄████░ ████░ ▄██████░ │■│┌───────────────────────────────┐│■│
██░ ██░ ██░ ██░ │■││ Your Company Name ││■│
██░ ██░ ██░ ██░ │■││ 12345 Orange Street ││■│
██████░ ██░ ██░ ███░ │■││ Suite 100A ││■│
██░ ██░ ██░ ██░ ██░ │■││ Anyplace, ST 12345-1234 ││■│
██░ ██░ ██░ ██░ ██░ │■│├───────────────────────────────┤│■│
██▀████░ ████░ ▀██████▀ │■││ Customer, ShipTo, Vendor ││■│
│■││ Address Line Here ││■│
█░ ▄█▄ █▄██░ ███░ █░ ▄██▄ │■││ Another Address Line ││■│
█░ █░█░ █░ █░ █░ █░ █░ │■││ City, State, ZIP ││■│
█░ █▄█░ █▄▄█░ ██░ █░ █▄▄▄ │■│└───────────────────────────────┘│■│
█░ █▀ ▀█░ █░ █░ █░ █░ █░ │■│┌───────────────────────────────┐│■│
███░ █░ █░ █▀██░ ███░ ███░ ▀██▀ │■││ Your Company Name ││■│
╔════════════════════════════════════════════════════════════════════════════╗
║Select Label Option -> Customer Bill To ║
║ Customer Ship To #1 ║
║ Customer Ship To #2 ║
║ Vendor Bill To ║
║ Vendor Ship To ║
║ Label Configuration ║
║ Line Feed ║
║ Exit ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ BIG LABELS CONFIGURATION
A default label configuration is shown in the following diagram, but you
can change it to fix another label...
╔════════════════════════════════════════════════════════════════════╗
║ Print Your Company Name & Address: Y ║
║ Print ATTN (Contact) Field: Y ║
║ Number of Lines per Label: 18 ║
║ Label Width (for centering): 40 ║
║ Starting Column: 0 ║
║ Starting Line For Your Address: 5 ║
║ Starting Line For Addressee: 12 ║
║ ║
║ Print Sample? (Y/N) ║
║ ║
║ Exit? (Y/N) ║
╚════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 37
■ CUSTOMER EXPANDED
This report is a modified version of the expanded customer report found
in DAYO AR Reports menu. This one has more options.
╔═[ Customer Expanded ]══════════════════════════════╗
║ Customer Expanded Report with Ship To Data. ║
║ Multiple Indexes. ║
║ Not a Report Form. ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
This report has 10 indexes to chose from:
╔═══════════════════════════════════════════════════════╗
║The Customer Expanded Report contains as much data ║
║for each customer that can fit onto a 132 character ║
║wide printout. * Includes Ship To Information also. ║
║ ║
║Not a Report Form. ║
║ ║
║Select the Index -> CUSTOMER ║
║ BILL TO NAME ║
║ SHIP TO NAME ║
║ LAST 4 DIGITS PHONE ║
║ BILL TO ZIP CODE ║
║ ATTENTION/CONTACT ║
║ BILL TO CITY ║
║ SHIP TO ZIP CODE ║
║ SALES PERSON CODE ║
║ FAX PHONE NUMBER ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
Most of the index options/selections require a temporary index:
┌──────────────────────────────────────────────────────────┐
│ Database Name: \DAYOAR\CUSTOMER.DBF │
│ Index Name: TEMPNTX7.NTX │
│ Number of Records: 302 │
│ ┌──────────────────────────────────────────────────┐ │
│ │████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 38
■ AP ADJUSTMENTS
This report prints all Accounts Payable (AP) records that appear to be
adjustments. AP adjustments have the following phrase in the COMMENT field:
***GL PAYABLES ADJUSTMENT***
╔═[ AP Adjustments ]═════════════════════════════════╗
║ ║
║ Accounts Payable Adjustments. ║
║ Multiple Indexes. ║
║ Not a Report Form. ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
After passing through all the prompts/options for this report, an
'exploding box' progress graph is displayed onto the screen.
╔══════════════════════════════════════════════════════┌────────────────────┐
║The Accounts Payable Adjustments Report will list │┌──────────────────┐│
║AP Header records that were created as a result of ││┌────────────────┐││
║making adjustments to one or more of the following │││┌──────────────┐│││
║fields: SUBTOTAL, FREIGHT, ADJUST, TAXES, PAID ││││┌────────────┐││││
║List all Detail for the payable also. │││││┌──────────┐│││││
║Date ranges supported. Not a Report Form (131 WIDE). ││││││┌────────┐││││││
║ │││││││┌──────┐│││││││
║Start Date: 12/01/89 End Date: 11/26/90 ││││││││┌────┐││││││││
║ │││││││││┌──┐│││││││││
║Select the Index -> PO NUMBER ││││││││││90││││││││││
║ │││││││││└──┘│││││││││
║Enter Number of Lines Per Page: 56 ││││││││└────┘││││││││
║ │││││││└──────┘│││││││
║Send Output to Printer? (Y/N) ││││││└────────┘││││││
║ ( No -> To File) │││││└──────────┘│││││
║Enter File Name: APADJ.TXT ││││└────────────┘││││
║ │││└──────────────┘│││
║TLJ 16 100012 S AF;LSDKFJAS;DFAS ││└────────────────┘││
╚══════════════════════════════════════════════════════│└──────────────────┘│
└────────────────────┘
■ BATCH INVENTORY ADJUSTMENTS
This is not a report. This routine provides a means of making batch
adjustments to the inventory (INV.DBF) quantity (ONHAND).
╔═[ Batch Inventory Adj ]════════════════════════════╗
║ ║
║ Batch Inventory Adjustments. ║
║ Routine to make inventory adjustments easier. ║
║ No report generated with this routine. ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 39
■ AR ADJUSTMENTS
This report prints all Accounts Receivable Header records that have
been closed (OPEN=.T.), and the amount collected does not equal the amount
charged. The most common occurance for this is when the customer pays only
a portion of an invoice, or receives some kind of discount from you.
╔═[ AR Adjustments ]═════════════════════════════════╗
║ ║
║ AR Adjustments. ║
║ Reports all Closed (OPEN=.F.) AR Invoices where ║
║ PAID <> SUBTOTAL + ADJUST + FREIGHT + TAXES ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
╔═══════════════════════════════════════════════════════╗
║The AR Adjustments Report prints all AR Header records ║
║that have been closed (OPEN=.F.), and the PAID field ║
║(amount received from the customer) does not equal the ║
║sum of SUBTOTAL+ADJUST+TAXES+FREIGHT. ║
║Uses Report Form: ARADJ.FRM. ║
║ ║
║Is this for ALL Customers? (Y/N) ║
║No -> Specific Customer ║
║Start Date: 11/28/80 Ending Date: 11/26/90 ║
║ ║
║Select Index -> INVOICE NUMBER ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: ARADJ.TXT ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 40
■ SPECIAL SALES REPORT I
This is the first of a 3 part set of sales reports. This one prints
sales data for a specific customer, sales person, class code, state,
ship state, zip, ship zip, shipper, or taxcode. The following information is
printed onto the report:
INVOICE NUMBER
CUSTOMER NUMBER
CUSTOMER PO
SALES PERSON (REP)
INVOICE TYPE
CLASS
TERMS
SHIPPER
ADJUSTMENT & FREIGHT TOTAL
SUBTOTAL
AMOUNT PAID
DATE OF INVOICE
╔═[ Special Sales Report I ]═════════════════════════╗
║ ║
║ Special Sales Report #1. ║
║ Reports all sales (Header Info) for a specific ║
║ CUSTOMER, SALES PERSON, CLASS CODE, STATE, ║
║ SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE. ║
║ ║
╚════════════════════════════════════════════════════╝
Many index options are available, but most require the creation of a
temporary index:
╔═══════════════════════════════════════════════════════╗
║Special Sales Report #1. ║
║Reports all sales (Header Info) for a specific ║
║CUSTOMER, SALES PERSON, CLASS CODE, STATE, ║
║SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE. ║
║Uses Report Forms: SALES1.FRM to SALES9.FRM. ║
║ ║
║Select Option -> CUSTOMER ║
║ SALES PERSON CODE * Requires Indexing ║
║ CLASS CODE * Requires Indexing ║
║ BILL TO STATE * Requires Indexing ║
║ SHIP TO STATE * Requires Indexing ║
║ BILL TO ZIP CODE * Requires Indexing ║
║ SHIP TO ZIP CODE * Requires Indexing ║
║ SHIPPER CODE * Requires Indexing ║
║ TAX CODE * Requires Indexing ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 41
Current Data can also be printed is defined as the range between the
Start Date and the End Date:
╔═══════════════════════════════════════════════════════╗
║Special Sales Report #1. ║
║Reports all sales (Header Info) for a specific ║
║CUSTOMER, SALES PERSON, CLASS CODE, STATE, ║
║SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE. ║
║Uses Report Forms: SALES1.FRM to SALES9.FRM. ║
║ ║
║Select Option -> SALES PERSON CODE * Requires Indexing ║
║ ║
║Enter Sales Person Code: ║
║ ║
║Start Date: 11/28/80 Ending Date: 11/26/90 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: SALES1.TXT ║
║ ║
║Enter Report Title: ACME PARTS SUPPLY, INC. ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
■ SPECIAL SALES REPORT II
This report prints similiar data to the 1st sales report, but with more
emphasis on summaries of sales. The following information is reported:
CUSTOMER NUMBER
CUSTOMER NAME
SALES PERSON (REP)
CLASS
PTD SALES
PTD PROFIT
PTD MARGIN
YTD SALES
YTD PROFIT
YTD MARGIN
CURRENT SALES
CURRENT PROFIT
CURRENT MARGIN
GROWTH RATE
*** The Growth Rate is a number between 1 and -1. It depicts the Profit
Trend for each customer and the report as a whole. A Growth Rate of around 0
means that profits for a customer are constant. A negative Growth Rate shows
a decrease in profits for a customer. A positive Growth Rate shows an
increase in profits for a customer.
DAYO Smart Reports, TJS LAB Page: 42
╔═[ Special Sales Report II ]════════════════════════╗
║ ║
║ Special Sales Report #2. Similiar to #1, but ║
║ computes data from the AR detail records ║
║ instead of the header records. Includes PTD, YTD ║
║ and Last Year sales/profit/margin information. ║
║ ║
╚════════════════════════════════════════════════════╝
A more elaborate date reporting system is defined in this report. The
user is prompted to enter the beginning and ending dates of last year,
current year and current period:
╔════════════════════════════[ SALES REPORT #2 ]═════════════════════════════╗
║Special Sales Report #2. ║
║Reports sales totals for a specific CUSTOMER, SALES PERSON, ║
║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ║
║Not a Report Form (150 characters wide!)... ║
║Select Option -> CLASS CODE * Requires Indexing ║
║ ║
║ Start of Last Year: 11/06/88 End of Last Year: 11/06/89 ║
║Start of Current Year: 11/07/89 End of Current Year: 11/06/90 ║
║ Start of Period: 10/01/90 End of Period: 10/31/90 ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Smart Reports, TJS LAB Page: 43
A progress graph is displayed to the right of the screen:
╔════════════════════════════[ SALES REPORT #2 ]═════════════════════▄▄▄▄▄▄▄▄▄
║Special Sales Report #2. ║100%┬──╫
║Reports sales totals for a specific CUSTOMER, SALES PERSON, ║ . │──║
║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ║ . │──║
║Not a Report Form (150 characters wide!)... ║ 83%┼──╫
║Select Option -> CLASS CODE * Requires Indexing ║ . │──║
║ ║ . │──║
║ Start of Last Year: 11/06/88 End of Last Year: 11/06/89 ║ 67%┼──╫
║Start of Current Year: 11/07/89 End of Current Year: 11/06/90 ║ . │──║
║ Start of Period: 10/01/90 End of Period: 10/31/90 ║ . │──║
║Enter Growth Rate Range Factor: 8 ║ 50%┼──╫
║Send Output to Printer? (Y/N) ( No -> To File) ║ . │──║
║Enter File Name: SALES2.TXT ║ . │──║
║Enter Number of Lines Per Page: 50 ║ 33%┼──╫
║Enter Report Title: ACME SUPPLY COMPANY, INC. ║ . │──║
║ ║ . │──║
║Enter CLASS Code: NC1 ║ 17%┼──╫
║ ║ . │██║
║ ║ . │██║
║ ║ 0%┴██╫
╚════════════════════════════════════════════════════════════════════▀▀▀▀▀▀▀▀▀
■ SPECIAL SALES REPORT III
This report is identical to the 2nd sales report except that it also
prints all the detail items/records. Using this report, you can identify
exactly what a customer/client has purchased. The additional item information
that is reported is:
INVOICE NUMBER
ITEM
DESCRIPTION
QTY
PRICE
COST
PROFIT
MARGIN
CLASS
╔═[ Special Sales Report III ]═══════════════════════╗
║ ║
║ Special Sales Report #3. Same as #2, but also ║
║ prints the detail records. ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 44
You can specify whether you want to print the detail lines for just the
current period, current year or for last year through current period:
╔════════════════════════════[ SALES REPORT #3 ]═════════════════════════════╗
║Special Sales Report #3. Prints every Invoice Detail record! ║
║Reports sales totals for a specific CUSTOMER, SALES PERSON, ║
║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM. ║
║Not a Report Form (150 characters wide!)... ║
║Select Option -> CLASS CODE * Requires Indexing ║
║ ║
║ Start of Last Year: 11/07/88 End of Last Year: 11/07/89 ║
║Start of Current Year: 11/08/89 End of Current Year: 12/31/90 ║
║ Start of Period: 10/01/90 End of Period: 12/31/90 ║
║Enter Growth Rate Range Factor: 12 ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: SALES3.TXT ║
║Enter Number of Lines Per Page: 50 ║
║Enter Report Title: dlksjhflksjdfsd ║
║Select Option -> Print Detail For Last Year Through Current Period ║
║ Print Detail For Current Year ║
║ Print Detail For Current Period ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
■ CUSTOMER LIST #2
This report is similiar to Customer List #1, except that multiple SHIP TO
information is also printed out.
╔═[ Customer List #2 ]═══════════════════════════════╗
║ ║
║ Customer List #2 with Ship To Names. ║
║ List the customer Bill To and Ship To names, ║
║ and telephone numbers. ║
║ ║
╚════════════════════════════════════════════════════╝
Multiple index options are presented:
Select the Index -> CUSTOMER
BILL TO NAME
SHIP TO NAME
LAST 4 DIGITS PHONE
BILL TO ZIP CODE
ATTENTION/CONTACT
BILL TO CITY
SHIP TO ZIP CODE
SALES PERSON CODE
DAYO Smart Reports, TJS LAB Page: 45
A progress graph depicting colored boxes is displayed onto the screen:
┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐
│10%││20%││30%││40%││50%││60%││70%││80%││90%││100│
└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘
■ EXAMPLE OF THE CUSTOMER LIST #2
ACME PARTS SUPPLY, INC. Page: 1
Customer List #2 (with Ship Tos) Date: 11/26/90
^^ Default Ship To ^ Multiple Ship To
Customer Name Phone
-------- ------------------------------ -------------- --------------------
2293 C & S Novelties 237-5555
2311 Rosedale Dataline
2313 Sherman Designs (302) 558-5555
2361 Software Support Customer
2362 The Programmer's Shop (637) 740-5555
2413 New England Comics (502) 583-5555
2457 Gertrude A. Ford 546-6327
2501 Roger Gay
2595 Bradford Board of Education
2624 SDN Project
2643 GAF Tel-Com
2644 Alan Harrison (803) 555-5555
2757 Electric Indicator Co., Inc. (803) 847-5555
2766 Rothrist Tube, Inc. (801) 670-4257
2775 Assc For Retarded Citizens
2780 Pinkstone & Marquez Inc. (904) 869-0100
2783 Atul Mitra (913) 469-2131
28011 Larry Thompson (407) 291-6987
2801^^ Larry Thompson #2 (407) 291-6987
2801^ Larry Thompson #3 (Martin) (407) 291-3960
2801^ Larry Thompson #4 (407) 291-3960
2801^ Larry Thompson #5 (Jose) (407) 291-3960
2801^ Larry Thompson #6 (Juan) (407) 291-3960
2801^ Larry Thompson #7 (Jesus) (407) 291-3960
2801^ Larry Thompson #8 (Mary) (407) 291-3960
2801^ Larry Thompson #9 (407) 291-3960
2801^ Larry Thompson #10 (407) 291-3960
2801^ Larry Thompson #11 (407) 291-3960
2801^ Larry Thompson #12 (Sal) (407) 291-3960
2801^ Larry Thompson #13 (407) 291-3960
2801^ Larry Thompson #14 (Joe) (407) 291-3960
2801^ Larry Thompson #15 (Debbie) (407) 291-3960
2919 Stereo Exchange, Inc.
2922 James J. Spinelli (804) 793-5555
2931 Vitron Management Consult. Inc (313) 793-5555
2979 Remee Products
2982 Home & City Savings Bank (802) 479-5555
3001 Computer Directions, Inc. (213) 834-5555
3023 Rick Guggemos
3048 Carolina Color Corporation
3317 Air Filter Service (803) 555-9321
DAYO Smart Reports, TJS LAB Page: 46
■ INSERT DECIMALS
This is not a report. This routine globally modifies the structure for
all quantity fields (ie: ONHAND, PTDSOLD, ORDERED, RECEIVED) in the following
databases: INV.DBF, ALLOCATE.DBF, APD.DBF, ARD.DBF, BO.DBF, BOM.DBF,
DETAIL.DBF, ENDITEMS.DBF, INVADJ.DBF, PHYINV.DBF, POD.DBF, QUOTESD.DBF,
REC.DBF, TEMPLATE.DBF, and WAREHOUS.DBF.
╔═[ Insert Decimals ]════════════════════════════════╗
║ ║
║ Insert Decimals into all databases with a ║
║ quantity field, ie: ONHAND in inventory... ║
║ This routine does not print anything! ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
The progress of the operation is scrolled onto the lower part of the
screen:
╔════════════════════════════════[ DECIMALS ]════════════════════════════════╗
║This routine will insert decimals in the quantity/onhand fields in all ║
║DAYO databases that have item quantity fields, ie: inventory, invoices, ║
║purchase orders, MRP, backorders, quotes, receipts, ... ║
║Check the database location options in the Configuration Menu to insure ║
║their accuracy. ║
║REQUIRES EXCLUSIVE USE OF THE DATABASES! * DO A FULL BACKUP FIRST! * ║
║IF ON A NETWORK, INSURE THAT NO ONE IS IN THE SYSTEM! ║
║USE WITH CAUTION! ║
║Decimals for the ONHAND field in the inventory is currently set to 2 ║
║Enter Number of Decimals: 2 ║
║ ║
║Are you sure you want to continue? (Y/N) ║
║ ║
║Last chance to abort! Are you really sure? (Y/N) ║
║ DATABASE FIELD TYPE LENGTH DECIMALS ║
║ INV BO N 10 2 ║
║ INV ONORDER N 10 2 ║
║ INV UNITQTY N 10 2 ║
║ INV ALLOCATED N 10 2 ║
║ INV SOLDPTD N 10 2 ║
╚════════════════════════════════════════════════════════════════════════════╝
*** Do Not Disturb Me While I Reconstruct The Databases! ***
DAYO Smart Reports, TJS LAB Page: 47
■ WAREHOUSE REORDER
This report does require a report form, and will automatically determine
and report any number of warehouses. Note, the width of the report increases
by 7 spaces for each additional warehouse. The report is 132 characters wide
with 10 (3 more than the default of 7) warehouses.
╔═[ Warehouse Reorder ]══════════════════════════════╗
║ ║
║ Warehouse Reorder Report. ║
║ Reports only the reorder quantity for warehouses ║
║ and the main warehouse (ONHAND). ║
║ ║
╚════════════════════════════════════════════════════╝
You have the option of printing only those items that require some kind
of reorder, or all:
╔══[ Warehouse Reorder ]═════════════════════════════╗
║■Print ONLY items requiring reorder? (Y/N) ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ( No -> To File) ║
║ Enter File Name: REWARE.TXT ║
╚════════════════════════════════════════════════════╝
A progress graph is displayed on to screen:
╔══════════════════════╗
║ ┌──────────────┐ ║
║ │ │ ║
║ │ │ ║
║ │██████████████│ ║
║ │██████████████│ ║
║ │██████████████│ ║
║ └─────╖ ╓─────┘ ║
║ ║██║ ║
║ ║ ║ ║
║ ┌─────╜██╙─────┐ ║
║ │100% │ ║
║ │80% ██ │ ║
║ │60% │ ║
║ │██████████████│ ║
║ │██████████████│ ║
║ ╔╧══════════════╧╗ ║
║ ║ PROGRESS GLASS ║ ║
║ ═╩════════════════╩═ ║
╚══════════════════════╝
DAYO Smart Reports, TJS LAB Page: 48
■ SERIAL NUMBERS IN
This report prints records from the database SERIALIN.DBF, found in the
DAYO Inventory directory. This report will print serial numbers that were
recorded when the items were received into the inventory.
╔═[ Serial Numbers In ]══════════════════════════════╗
║ ║
║ Serial Numbers In Report. ║
║ Reports records of serial numbers recorded at time ║
║ of receipt into the inventory. ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
You can specify a 'range' of serial number records to print, or all:
╔═════════════════════════════════════════════════════════════════╗
║ This report will print serial numbers that were recorded ║
║ when the items were received into the inventory. ║
║ ║
║ Select Option -> Specific Purchase Order Number ║
║ Specific ITEM Number ║
║ Specific CONTROL Number ║
║ Specific VENDOR Number ║
║ Specific Serial Number ║
║ From/To Dates ║
║ All ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚═════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Smart Reports, TJS LAB Page: 49
■ EXAMPLE OF THE SERIAL NUMBER IN REPORT
Page No. 1 Specific Control Number: ABC Indexed on Control Number
11/26/90
SERIAL NUMBER IN
SERIAL NUMBER ITEM PO KEY CONTROL VENDOR DATE
--------------- ------------ ------ ------ ---------- ---------- --------
123A56-10775 286CPU-1 233 2931 TJ-3990 TJS LAB 03/02/90
1234A6-10797 286CPU-1 323 2941 TJ-3990 TJS LAB 03/18/90
1234D6-10343 286CPU-3 344 3121 TJ-3990 TJS LAB 03/13/90
1234D6-14044 286CPU-1 383 3245 TJ-3990 TJS LAB 04/17/90
1234F6-10425 286CPU-4 387 3323 TJ-3990 TJS LAB 06/04/90
123436-10253 286CPU-1 394 3444 TJ-3990 TJS LAB 06/10/90
123436-12342 286CPU-3 397 3534 TJ-3990 TJS LAB 08/31/90
1234D6-103SG 286CPU-3 411 3604 TJ-3990 TJS LAB 09/02/90
1234R6-10333 286CPU-3 433 3755 TJ-3990 TJS LAB 10/11/90
123436-10222 286CPU-1 458 3800 TJ-3990 TJS LAB 11/21/90
■ SERIAL NUMBERS OUT
This report will print serial numbers that were recorded when the items
were invoiced using DAYO Point of Sale (POS).
╔═[ Serial Numbers Out ]═════════════════════════════╗
║ ║
║ Serial Numbers Out Report. ║
║ Reports records of serial numbers recorded at time ║
║ of invoicing (in POS). ║
║ ║
╚════════════════════════════════════════════════════╝
■ EXAMPLE OF THE SERIAL NUMBER OUT REPORT
Page No. 4 Print All Records Indexed on Serial Number
11/26/90
SERIAL NUMBERS OUT (POS)
SERIAL NUMBER ITEM INVOICE CUSTOMER DATE
--------------- ------------ ------- -------- --------
12345-1292 PRINTER #3 205 6223 09/04/90
A2 242-2 42 PRINTER #4 225 3002 10/11/90
A2 3223-3 23
A2 213-23 2
TS-393 ALLL143 261 1100 11/13/90
TS-38 ALLL143 259 2999 11/14/90
TS-393 ALLL143 259 2999 11/16/90
TS-89 ALLL143 259 2999 11/21/90
TS-392A ALLL143 259 2999 11/22/90
TOM#9301 TOM TOM 244 4100 11/23/90
12345-12345 AC2334 245 4340 11/26/90
DAYO Smart Reports, TJS LAB Page: 50
■ BAD RECORDS
This report was created to provide a means for users to find and fix Bad
records. Bad records created when bad data is placed in one or more fields of
a record. A leading cause of this is the rebooting of the machine while it
is writing or updating a database.
╔═[ Bad Records ]════════════════════════════════════╗
║ ║
║ Find & Fix Bad Records. ║
║ * Requires Exclusive Use of Databases * ║
║ * Dangerous Operation - Backup First! * ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
The progress of this operation is displayed onto the screen:
╔════════════════════════════════════════════════════════════════════════════╗
║ Checking: \DAYOPOS\DETAIL.DBF ║
╚════════════════════════════════════════════════════════════════════════════╝
╔════════════════════════════════════════════════════════════════════════════╗
║ ■ Standby while I check out: \DAYOPOS\DETAIL.DBF ║
║ Checking record: 597 ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 51
■ RESET ALLOCATED
This routine will reset the field 'ALLOCATED' in the inventory database
(INV.DBF) to zero (0), then recompute the allocated quantity by counting up
the number of items currently on open work orders (invoices not printed).
The progress of the process is displayed onto the graph in the form
of an hour glass.
DAYORPT V3.0, TJS LAB ┌───[January 1991]───┐
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ │S M T W T F S │
╔═════█┌──────────────┐█═╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
║Inser█│ │█ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│
║Inser█│ │█ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│
║Wareh█│██████████████│█ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│
║Seria█│██████████████│█ ║ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│
║Seria█│██████████████│█ ║ ████▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │
║Bad R█└─────╖ ╓─────┘█ ║ │ │
║Reset▀▀▀▀▀▀█║ ║█▀▀▀▀▀▀ ║ └────────────────────┘
║Reset▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ ╠═[ Reset Allocated ]═══════════════════════════════╗
║Set/R█┌─────╜ ╙─────┐█ ║ ║
║Repor█│100% │█ ║ Reset the ALLOCATED field in the inventory ║
║Print█│80% │█ ║ database (INV.DBF) based on open work orders ║
║Misc █│60% │█ ║ and back orders. ║
╠═════█│██████████████│█═╣ ║
║ Pre█│██████████████│█ ║ ║
╚═════█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█═╩═══════════════════════════════════════════════════╝
▄███ PROGRESS GLASS █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄
█░▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░
█░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░
▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄
█░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░
▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀
Recomputing ALLOCATED from Work Orders... Esc (Abort)
DAYO Smart Reports, TJS LAB Page: 52
■ RESET BO - BACK ORDER QUANTITY
This routine will reset the field 'BO' in the inventory database
(INV.DBF) to zero (0), then recompute the BO quantity by counting up
the number of items currently on open invoices in the Back Order database
(BO.DBF).
The progress of the process is displayed onto the graph in the form
of an hour glass.
DAYORPT V3.0, TJS LAB ┌───[January 1991]───┐
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ │S M T W T F S │
╔═════█┌──────────────┐█═╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
║Inser█│ │█ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│
║Inser█│ │█ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│
║Wareh█│ │█ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│
║Seria█│██████████████│█ ║ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│
║Seria█│██████████████│█ ║ ████▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │
║Bad R█└─────╖ ╓─────┘█ ║ │ │
║Reset▀▀▀▀▀▀█║ ║█▀▀▀▀▀▀ ║ └────────────────────┘
║Reset▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ ╠═[ Reset BO ]══════════════════════════════════════╗
║Set/R█┌─────╜ ╙─────┐█ ║ ║
║Repor█│100% │█ ║ Reset the BO field in the inventory ║
║Print█│80% │█ ║ database (INV.DBF) based on the number of ║
║Misc █│██████████████│█ ║ open back orders in database: BO.DBF. ║
╠═════█│██████████████│█═╣ ║
║ Pre█│██████████████│█ ║ ║
╚═════█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█═╩═══════════════════════════════════════════════════╝
▄███ PROGRESS GLASS █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄
█░▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░
█░ █░█░█░ █░█░ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░
▀██▄ █░█░█░ █▄█░ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄
█░ █░▀ █░ █▀ ▀█░ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░
▀██▀ █░ █░ █░ █░ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀
Resetting BO to Zero (0)... Esc (Abort)
DAYO Smart Reports, TJS LAB Page: 53
■ SET MULTIPLE PRICE FIELDS IN INVENTORY
Use this routine to determine and set the multiple price fields 'PRICE1
to PRICE5' based on a List (Retail Price) discount or on a cost plus (Margin)
method.
Note, the 5 price fields must exist in the inventory database (INV.DBF),
and if not, use the DAYO Update & Conversion program to place them there.
╔═════════════════[ SET MULTIPLE PRICE FIELDS IN INVENTORY ]════════════════╗
║ ║
║This routine will reset the mulitple price fields: PRICE1, PRICE2, PRICE3, ║
║PRICE4, PRICE5, based on a margin or list (RETAIL) discount method. ║
║ ║
║ ║
║ Field (M)argin ║
║ Name (L)ist Discount ║
║ PRICE1 M 50.000 ║
║ PRICE2 M 40.000 ║
║ PRICE3 M 30.000 ║
║ PRICE4 M 20.000 ║
║ PRICE5 M 10.000 ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Smart Reports, TJS LAB Page: 54
■ MULTIPLE PRICING PROGRESS GRAPH
The progress of the Multiple Price update is displayed onto the screen
with an hour glass and a scroll of the items.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
╔════█┌──────────────┐█ MULTIPLE PRICE FIELDS IN INVENTORY ]════════════════╗
║ █│ │█ ║
║This█│ │█t the mulitple price fields: PRICE1, PRICE2, PRICE3, ║
║PRIC█│██████████████│█on a margin or list (RETAIL) discount method. ║
║ █│██████████████│█ ║
║ █│██████████████│█ ║
║ █└─────╖ ╓─────┘█ Field (M)argin ║
║ ▀▀▀▀▀▀█║ ║█▀▀▀▀▀▀ Name (L)ist Discount ║
║ ▄▄▄▄▄▄█║ ║█▄▄▄▄▄▄ PRICE1 M 50.000 ║
║ █┌─────╜ ╙─────┐█ PRICE2 M 40.000 ║
║ █│100% │█ PRICE3 M 30.000 ║
║ █│80% │█ PRICE4 M 20.000 ║
║ █│60% │█ PRICE5 M 10.000 ║
║ █│██████████████│█ ║
║ █│██████████████│█ Item PRICE1 PRICE5 ║
║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ APSBH-1 30.99 17.22 ║
║ █ PROGRESS GLASS █ YKEL245 28.92 16.07 ║
║ ▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ YKEL145 26.86 14.92 ║
║ YK90086 24.79 13.77 ║
║ J234324 22.73 12.63 ║
║ I354534 20.66 11.48 ║
╚═══════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Smart Reports, TJS LAB Page: 55
■ MODIFY SCREEN COLORS
This routine provides you with a means of modifying or altering any
color combination in any of the DAYO modules.
No Report is printed...
This routine optionally creates a color file (database) in a DAYO
module directory named COLORSET.DAT. When a DAYO module starts up, it looks
for this file in its current directory, and if found uses the color settings
in this file instead of the default colors. Erase it if you want to return
to the default colors!
╔═[ Modify Screen Colors ]═══════════════════════════╗
║ ║
║ Modify Screen Colors in Any DAYO Module. ║
║ Use this routine to alter the colors in any ║
║ DAYO Module. ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
■ COLOR CHART
The following is the initial screen for this option:
╔════════════════╦════════╦═══════════════════╦═════════════════════════════╗
║ Color ║ Letter ║ Monochrome ║ * Creates a blinking effect ║
╠════════════════╬════════╬═══════════════════╬═════════════════════════════╝
║ Black ║ N ║ Black ║ ▄███░ ▄██▄ █░ ▄██▄ █▄██░
║ Blue ║ B ║ Underline ║ █░ █░ █░ █░ █░ █░ █░ █░
║ Green ║ G ║ White ║ █░ █░ █░ █░ █░ █░ ████░
║ Cyan ║ BG ║ White ║ █░ █░ █░ █░ █░ █░ █░█░
║ Red ║ R ║ White ║ ▀███░ ▀██▀ ████░ ▀██▀ █░██░
║ Magenta ║ RB ║ White ║
║ Brown ║ GR ║ White ║ █████░ █░ █▄██░ █░ ███░
║ White ║ W ║ White ║ █░ █▀█░ █░ █░ █░ █░
║ Gray ║ N+ ║ White ║ █░ █░█░ █▀▀█░ █░ ██░
║ Bright Blue ║ B+ ║ Bright Underline ║ █░ ██▄██░ █░ █░ █░ █░
║ Bright Green ║ G+ ║ Bright White ║ █░ █░ █░ █▀██░ ████░ ███░
║ Bright Cyan ║ BG+ ║ Bright White ║
║ Bright Red ║ R+ ║ Bright White ║ This routine allows you to
║ Bright Magenta ║ RB+ ║ Bright White ║ modify/alter the screen
║ Yellow ║ GR+ ║ Bright White ║ colors for any DAYO module.
║ Bright White ║ W+ ║ Bright White ║ Read a dBase (tm) or Clipper
║ Black ║ U ║ Underline ║ (tm) manual for more
║ Inverse Video ║ I ║ Inverse Video ║ information on screen color
║ Blank ║ X ║ Blank ║ codes...
╚════════════════╩════════╩═══════════════════╝
Press any key to continue...
DAYO Smart Reports, TJS LAB Page: 56
Select the module you wish to install or modify colors in:
╔══════════════════════════[ MODIFY SCREEN COLORS ]══════════════════════════╗
║ Select Module -> DAYO Menu ║
║ █▄██ Inventory, Purchasing, Receiving █▄██ ║
║ █ █ POS, Point of Sale █ █ ║
║ █ █ Time & Billing █ █ ║
║ █▀██ AR, Accounts Receivable █▀██ ║
║ AP, Accounts Payable ║
║ █ GL, General Ledger █ ║
║ █▀█ Look Up DAYO Databases █▀█ ║
║ ██▄██ Payroll ██▄██ ║
║ █ █ Quotes █ █ ║
║ Back Orders ║
║ █ █ MRP, Materials Requirement Planning █ █ ║
║ ▀█▄█▀ Price Books, Lists ▀█▄█▀ ║
║ █ Bar Codes █ ║
║ █ Index █ ║
║ End of Period, Physical Inventory ║
║ ▄██▄ Smart Reports ▄██▄ ║
║ █ █ Passwords █ █ ║
║ █ █ Graphic Reports █ █ ║
║ ▀██▀ Sales Contacts ▀██▀ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) Enter/Return (Select)
The following message is displayed onto the screen if colors are to
modified for the first time in a particular module:
╔══════════════════════════════════════════════════════════════════════════╗
║ Color File Not Installed In: DAYO Menu ║
║ ║
║ Install? (Y/N) ║
╚══════════════════════════════════════════════════════════════════════════╝
If you responded 'Y' Yes to the install prompt, you will then be prompted
to enter the location of the selected DAYO module:
╔══════════════════════════════════════════════════════════════════════════╗
║ Color File Not Installed In: DAYO Menu ║
║ (ie: C:\DAYOPOS\) ║
║ Enter Drive/Directory/Location: \DAYO\ ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 57
Finally, you will be presented with an edit screen of the 18 color code
combinations:
╔══════════════════════════[ MODIFY SCREEN COLORS ]══════════════════════════╗
║ ║
║ #1 Red: R+/n,n/W,n/w,,n/w █▄██ ║
║ #2 White: W+/n,n/w,n/w,,n/w █ █ ║
║ #3 White on Red: W+/R,n/w,n/w,,n/w █ █ ║
║ #4 Black on Red: RG+/R,n/w,n/w,,n/w █▀██ ║
║ #5 White on Blue: W+/B,n/w,n/w,,n/w ║
║ #6 Blinking White on Red: W+*/R,n/w,n/w,,n/w █ ║
║ #7 Blinking White on Blue: W+*/B,n/w,n/w,,n/w █▀█ ║
║ #8 Blue: B+/n,n/w,n/w,,n/w ██▄██ ║
║ #9 Cyan: BG/N,n/w,n/w,,n/w █ █ ║
║ #10 Green: G/n,n/w,n/w,,n/w ║
║ #11 Magenta: BR+/n,n/w,n/w,,n/w █ █ ║
║ #12 Yellow: RG+/n,n/w,n/w,,n/w ▀█▄█▀ ║
║ #13 Blinking Cyan: BG/N,n/w,n/w,,n/w █ ║
║ #14 Blinking Red: R+*/n,n/w,n/w,,n/w █ ║
║ #15 Blinking Green: G+*/n,n/w,n/w,,n/w ║
║ #16 Blinking White: W+*/n,n/w,n/w,,n/w ▄██▄ ║
║ #17 Blinking Yellow: RG+*/n,n/w,n/w,,n/w █ █ ║
║ #18 Blinking Magenta: BR+*/n,n/w,n/w,,n/w █ █ ║
║ ▀██▀ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
Colors Settings: STANDARD,ENHANCED,BORDER
ie: W+/N,N/W,W/N
Standard Main Screen Output
Enhanced Prompts and Selection Highlights
Border Border (Not on EGA & VGA Monitors...)
Each of the above colors settings consists of 2 parts; the foreground and
the background. The foreground and background is separated by a forward
slash (/). The main colors are separated by a comma, ie: W+/N,N/W,W/N
Foreground color settings can also have high intensity or blinking
attributes. Add a plus sign '+' for high intensity; an asterisk '*' for
blinking.
High Intensity Example: W+/N
Blinking Example: W*/N
Blinking, High Intensity Example: W+*/N
DAYO Smart Reports, TJS LAB Page: 58
■ ITEM TRACKER
This is perhaps one of the 'smartest' Smart Reports. Use this report
to tracking Item movement within your company for a selected date range.
'Everything' about an Item is printed out from Inventory Adjustments
(INVADJ.DBF), Receipts (REC.DBF) and Sales (ARD.DBF). The ONHAND quantity
in the inventory database (INV.DBF), ONHAND quantity in the last inventory
database (LASTINV.DBF) and the sum of the counted Items in the physical
inventory is also printed. At the end of the report, the physical and
last inventory databases are checked to see if they contain items not
found in the inventory database.
* Note, to insure proper sales reporting, be sure to perform the AR
Post. This routine 'moves' closed/printed invoices into AR from DAYO POS.
╔═[ ITEM TRACKER ]═══════════════════════════════════╗
║ ║
║ Complete Period Item Summary - ITEM TRACKER. ║
║ Print out start/end inventory quantity, receipts, ║
║ sales, and inventory adjustments (by item). ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
This report may take 'quite a while' to run due to the large number of
files and records it has to go through...
DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐
╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗
║ ║
║ This report prints out the starting and ending quantities for every item ║
║ (from your current and physical inventory), receipts, sales (from posted ║
║ invoices in AR), Work in Process (from MRP) and inventory adjustments. ║
║ ║
║ Use this report to track/determine 'variances' in the physical inventory. ║
║ ║
║ This report may take 'quite a while' to run due to the large number of ║
║ files and records it has to go through... ║
║ ║
║ Enter Starting Date: 01/05/90 Ending Date: 02/04/91 ║
║ ║
║ ║
║ ║
║ ████████░ ██▄███░ ███░ ▄████░ ██░ ██░ █████░ ██▄███░ ║
║ ██░ ██░ ██░ ██▀██░ ██░ ██░▄██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ║
║ ██░ ██████░ ██░██░ ██░ ████░ ████░ ██████░ ║
║ ██░ ██░██░ ██▄██░ ██░ ██░██░ ██░ ██░██░ ║
║ ██░ ██░███░ ██▀ ▀██░ ██░ ██░▀██░ ██░ ██░▀██░ ║
║ ██░ ██░ ██░ ██░ ██░ ▀████░ ██░ ██░ █████░ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 59
Options for this report include the start/end dates, track all or a
specific item, specify the Physical Inventory or Last Inventory database
file, number of lines per page and to direct output to printer or file.
DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐
╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗
║ Enter Starting Date: 01/05/90 Ending Date: 02/04/91 ║
║ ║
║ Track ALL Items! ║
║ ║
║ Print all transactions for item? (Y/N) ║
║ ║
║ Physical Inventory Database: \DAYOEOP\PHYINV.DBF ║
║ ║
║ Last Inventory Database: \DAYOEOP\LASTINV.DBF ║
║ ║
║ Enter number of lines per page: 55 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: TRAC0291.TXT ║
║ ████████░ ██▄███░ ███░ ▄████░ ██░ ██░ █████░ ██▄███░ ║
║ ██░ ██░ ██░ ██▀██░ ██░ ██░▄██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ║
║ ██░ ██████░ ██░██░ ██░ ████░ ████░ ██████░ ║
║ ██░ ██░██░ ██▄██░ ██░ ██░██░ ██░ ██░██░ ║
║ ██░ ██░███░ ██▀ ▀██░ ██░ ██░▀██░ ██░ ██░▀██░ ║
║ ██░ ██░ ██░ ██░ ██░ ▀████░ ██░ ██░ █████░ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 60
The progress of this report is scrolled onto the screen for the 1st pass
through the inventory database (INV.DBF). After reporting all items in the
inventory database, the physical inventory and last inventory databases are
checked for items not in the inventory database.
DAYO Smart Reports Version 3.0, TJS LAB ┌───[February 1991]──┐
╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗
║ ████████░ ██▄███░ ███░ ▄████░ ██░ ██░ █████░ ██▄███░ ║
║ ██░ ██░ ██░ ██▀██░ ██░ ██░▄██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ║
║ ██░ ██████░ ██░██░ ██░ ████░ ████░ ██████░ ║
║ ██░ ██░██░ ██▄██░ ██░ ██░██░ ██░ ██░██░ ║
║ ██░ ██░███░ ██▀ ▀██░ ██░ ██░▀██░ ██░ ██░▀██░ ║
║ ██░ ██░ ██░ ██░ ██░ ▀████░ ██░ ██░ █████░ ██░ ██░ ║
║ Item Description Current Physical LastINV║
║ A800470 T/A 16 X 25 X 2 501.49 4900 501.49║
║ A800460 T/A 16 X 20 X 2 767.58 12300 491.25║
║ A800460 T/A 16 X 20 X 2 491.25 12300 491.25║
║ A800390 T/A 24 X 30 X 1 337.74 3300 337.74║
║ A800070 T/A 10 X 20 X 1 777.81 7600 0.00║
║ A800040 T/A 20 X 25 X 1 450.31 4400 450.31║
║ A800030 T/A 20 X 20 X 1 798.28 7800 0.00║
║ A200695 6-85D36 20X20X36 828.99 8100 0.00║
║ A200122 AP-15 20 X 25 X 2 685.70 6700 685.70║
║ A200041 AP-11 16 X 20 X 2 532.19 5200 532.19║
║ A100230 30/30 18 X 24 X 2 788.05 7700 0.00║
║ A100130 30/30 24 X 24 X 2 347.97 3400 347.97║
║ A100110 30/30 20 X 25 X 2 757.35 7400 0.00║
╚════════════════════════════════════════════════════════════════════════════╝
Record: 30/ 138 Esc (Exit/Abort)
DAYO Smart Reports, TJS LAB Page: 61
■ AR DISCREPANCIES
This reports invoices (receivables), that may have a error in the
SUBTOTAL as compared to the sum of the detail. Note, some receivables
may not have any detail...
╔═[ AR Discrepancies ]═══════════════════════════════╗
║ ║
║ AR Detail/Subtotal Discrepancy Report. ║
║ Prints out receivables that have a SUBTOTAL not ║
║ equal to the sum of the line items. ║
║ Use to display/debug manual AR adjustments. ║
║ ║
╚════════════════════════════════════════════════════╝
Options include a start & end date and to direct the output to
printer or file.
╔════════════════════════════════════════════════════════════════════════════╗
║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║
║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║
║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║
║ ██▄██░█░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║
║ █░ █░█░██░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report will print out invoice and customer information for any ║
║ receivable which has a SUBTOTAL value not equal to the sum of its detail ║
║ line items. This happens when the SUBTOTAL is adjusted after the record ║
║ is posted into the AR database (ARH.DBF) ║
╟────────────────────────────────────────────────────────────────────────────╢
║ ║
║Enter Start Date: 04/20/91 End Date: 05/20/91 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: ARBUG.TXT ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Smart Reports, TJS LAB Page: 62
The progress of the report is scrolled upon the screen.
╔════════════════════════════════════════════════════════════════════════════╗
║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║
║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║
║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║
║ ██▄██░█░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║
║ █░ █░█░██░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report will print out invoice and customer information for any ║
║ receivable which has a SUBTOTAL value not equal to the sum of its detail ║
║ line items. This happens when the SUBTOTAL is adjusted after the record ║
║ is posted into the AR database (ARH.DBF) ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Invoice Customer Ship To Name ADJUSTMENT ║
║ 100020 35111 ESHLEY ALUMINUM,INC. 348.33 ║
║ 100019 32504 ESHE INDUSTRIES,INC. 64.88 ║
║ 100018 23507 ERMSTRONG ALUMINUM 2.48 ║
║ 100017 53296 EMERICAN LIFESTYLE, INC. 34.66 ║
║ 100016 23579 ELUMINUM SPECIALTIES 88.55 ║
║ 100015 52779 ELUMINUM SPECIALTIES .77 ║
║ 100014 15359 ELUMINUM SPECIALTIES 252.55 ║
║ 100013 15379 ELUMINUM SPECIALTIES 316.49 ║
║ 100012 51351 ELUMINUM ACCENTS 327.44 ║
╚════════════════════════════════════════════════════════════════════════════╝
Standby, Printing Report! Esc (Abort/Exit)
■ EXAMPLE OF AR BUG REPORT
ACCOUNTS RECEIVABLE DISCREPANCIES Page 1
From 04/20/91 to 05/20/91 Date 05/20/91
CD Codes: O -> Open C -> Closed D -> Deleted/Voided
Invoice Customer Ship To Name SUBTOTAL DETAIL ADJUSTMENT CD
------- -------- ------------------------- ---------- ---------- ---------- --
100002 7999 ALL SCREEN SERVICE 1.00 1.50 .50 O
100003 7999 ALL SCREEN SERVICE 2.00 2.50 .50 O
100004 7999 ALL SCREEN SERVICE 3.00 2.50 -.50 O
------- -------- ------------------------- ---------- ---------- ---------- --
*** Totals *** 6.00 6.50 .50
DAYO Smart Reports, TJS LAB Page: 63
■ AP DISCREPANCIES
Use this report to find discrepancies in your payables. It reports any
payables with a SUBTOTAL not equal to the sum of the detail. Note, many
payables may not have any detail records.
╔═[ AP Discrepancies ]═══════════════════════════════╗
║ ║
║ AP Detail/Subtotal Discrepancy Report. ║
║ Prints out payables that have a SUBTOTAL not equal ║
║ to the sum of the line items. ║
║ Use to display/debug manual AP adjustments. ║
║ ║
╚════════════════════════════════════════════════════╝
Options include a start & end date and to direct the output to
printer or file.
╔════════════════════════════════════════════════════════════════════════════╗
║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║
║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║
║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║
║ ██▄██░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║
║ █░ █░█░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report will print out invoice and PO information for any payable ║
║ which has a SUBTOTAL value not equal to the sum of its detail line items. ║
║ This happens when the SUBTOTAL is adjusted after the record is posted into ║
║ the AP database (APH.DBF) ║
╟────────────────────────────────────────────────────────────────────────────╢
║ ║
║Enter Start Date: 04/20/91 End Date: 05/20/91 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: APBUG.TXT ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Smart Reports, TJS LAB Page: 64
The progress of the report is scrolled upon the screen.
╔════════════════════════════════════════════════════════════════════════════╗
║ ▄█▄ █▄██░ █▄██░███░███░███░█▄██░███░█▄██░ ▄█▄ █░ █░███░███░███░███░ ║
║ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░ █░ █░ ║
║ █░█░ ████░ █░ █░ █░ ███░█░ ████░██░ ████░ █░█░ ████░█░ █░ ██░ ███░ ║
║ ██▄██░█░ █░ █░ █░ █░█░ █░█░ █░ █░ ██▄██░█░██░█░ █░ █░ █░ ║
║ █░ █░█░ █▀██░███░███░███░█░██░███░█░ █░ █░█░ █░███░███░███░███░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report will print out invoice and PO information for any payable ║
║ which has a SUBTOTAL value not equal to the sum of its detail line items. ║
║ This happens when the SUBTOTAL is adjusted after the record is posted into ║
║ the AP database (APH.DBF) ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Journal PO Vendor Name ADJUSTMENT ║
║ 16 70007 SOUTH DISTRIBUTORS 337.84 ║
║ 15 70007 SOUTH DISTRIBUTORS 485.82 ║
║ 14 70007 SOUTH DISTRIBUTORS 68.70 ║
║ 13 70007 SOUTH DISTRIBUTORS 485.57 ║
║ 12 70007 SOUTH DISTRIBUTORS 668.60 ║
║ 11 70007 SOUTH DISTRIBUTORS 056.05 ║
║ 10 70007 SOUTH DISTRIBUTORS 470.71 ║
║ 9 70005 SOUTH DISTRIBUTORS 30.10 ║
║ 0 70006 SOUTH DISTRIBUTORS 50.26 ║
╚════════════════════════════════════════════════════════════════════════════╝
Standby, Printing Report! Esc (Abort/Exit)
■ EXAMPLE OF AP BUG REPORT
ACCOUNTS PAYABLE DISCREPANCIES Page 1
From 04/20/91 to 05/20/91 Date 05/20/91
CD Codes: O -> Open C -> Closed D -> Deleted/Voided
Journal PO Name SUBTOTAL DETAIL ADJUSTMENT CD
------- -------- ------------------------- ---------- ---------- ---------- --
2 1001 GEORGE MOONILAL 100.00 77.00 23.00 O
3 1001 GEORGE MOONILAL 200.00 180.00 20.00 C
4 1001 SOUTH DISTRIBUTORS 300.00 306.00 -6.00 O
------- -------- ------------------------- ---------- ---------- ---------- --
*** Totals *** 600.00 563.00 37.00
DAYO Smart Reports, TJS LAB Page: 65
■ RENTAL REPORT, RENTALS OUT
This report is tied to the DAYO RENTAL POS module. It specifically
reports only invoice TYPE: 'REN'.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░ ███░ █░ █░ █████░ █░ █░ █▄██░ ███░ █▄██░ ▄██▄ █▄██░ █████░ ║
║ █░ █░ █░ ██░█░ █░ █▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ ████░ ██░ ████░ █░ █░█░ █░ ████░ ██░ █▀██░ █░ █░ ████░ █░ ║
║ █░█░ █░ █░██░ █░ █████░ █░ █░█░ █░ █░ █░ █░ █░█░ █░ ║
║ █░██░ ███░ █░ █░ █░ █░ █░ ███░ █░██░ ███░ █░ ▀██▀ █░██░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report prints out invoices (from the database: INVOICE.DBF) with the ║
║ type of 'REN'. The option to print only those that are late and/or past ║
║ due is given. You also have the option to print 'Header' information ║
║ with 'Detail' information, or just the 'Detail' information. ║
║ ║
║ Select Report Option -> Rental Header with Detail - Late Only ║
║ Rental Header with Detail - All Open ║
║ Rental Detail - Late Only ║
║ Rental Detail - All Open ║
║ Exit ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
Many options exists, ie: index, number of lines per page, and direct
output to printer or disk file.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░ ███░ █░ █░ █████░ █░ █░ █▄██░ ███░ █▄██░ ▄██▄ █▄██░ █████░ ║
║ █░ █░ █░ ██░█░ █░ █▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ ████░ ██░ ████░ █░ █░█░ █░ ████░ ██░ █▀██░ █░ █░ ████░ █░ ║
║ █░█░ █░ █░██░ █░ █████░ █░ █░█░ █░ █░ █░ █░ █░█░ █░ ║
║ █░██░ ███░ █░ █░ █░ █░ █░ ███░ █░██░ ███░ █░ ▀██▀ █░██░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report prints out invoices (from the database: INVOICE.DBF) with the ║
║ type of 'REN'. The option to print only those that are late and/or past ║
║ due is given. You also have the option to print 'Header' information ║
║ with 'Detail' information, or just the 'Detail' information. ║
║ ║
║ Select Report Option -> Rental Header with Detail - Late Only ║
║ ║
║ Select Index -> Invoice Number ║
║ ║
║ Enter Number of Lines Per Page: 55 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: RENTAL.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Smart Reports, TJS LAB Page: 66
■ CHANGE ITEM NUMBER
This routine makes changing an item number(s) easier. Use this option
to change item numbers in batch, or in the inventory AND the current
invoice detail database (DETAIL.DBF).
Note, it is not recommended that item numbers be changed...
╔═[ Change ITEM Number ]═════════════════════════════╗
║ ║
║ Change Item Number. Use this option to change ║
║ existing Item Numbers in the Inventory (INV.DBF), ║
║ and (optionally), the Invoice Detail database ║
║ (DETAIL.DBF). ║
║ ║
╚════════════════════════════════════════════════════╝
A browse screen of the entire inventory database is presented to
you to find and then select an item to be changed.
╔════════════════════════════════════════════════════════════════════════════╗
║▄████░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██████░ ████░ ██░ ██░║
║██░ ██░ ██░ ████░ ███░██░ ██░ ██░ ██░ ██░ ██░ ███░███░║
║██░ ██████░ ██░ ██░ ██████░ ██░███░ ███░ ██░ ██░ ███░ ███████░║
║██░ ██░ ██░ ██████░ ██▀███░ ██░ ██░ ██░ ██░ ██░ ██░ ██░█░██░║
║▀████░ ██░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██░ ████░ ██░ ██░║
╟────────────────────────────────────────────────────────────────────────────╢
║ This routine will allow you to change an existing Inventory Item ║
║ Number. Option to change the Description, Vendor, and Venditem. ║
║ Will optionally change open invoice detail records. NOT A REPORT. ║
╟─────────────────────────[ SELECT ITEM TO CHANGE ]──────────────────────────╢
║ITEM DESC ONHAND ONORDER BO ║
║─────────────╥────────────────────────────────╥─────────╥─────────╥─────────║
║1051232P1 ║ 1051232P1 LAMP ║ 10 ║ 0 ║ 3 ║
║1245G1 ║ A2251245G1 REGISTER ASSEMBLY ║ 0 ║ 0 ║ 0 ║
║1246G1 ║ A2251246G1 REGISTER ASSEMBLY ║ 0 ║ 4 ║ 2 ║
║1247G1 ║ A2251247G1 ║ 0 ║ 4 ║ 0 ║
║1257791G51 ║ 1B32083-1S ║ 0 ║ 1 ║ 0 ║
║45FB-45 ║ 24X24X8-3/4 FILT. W.HOUSING ║ 22 ║ 0 ║ 0 ║
║6-40A16 ║ 24X24X15 ║ 0 ║ 0 ║ 0 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) Enter/Return (Select)
Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type)
1372/1400
DAYO Smart Reports, TJS LAB Page: 67
The option to change the description, second description, vendor, and
vendor part number also exists...
╔════════════════════════════════════════════════════════════════════════════╗
║▄████░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██████░ ████░ ██░ ██░║
║██░ ██░ ██░ ████░ ███░██░ ██░ ██░ ██░ ██░ ██░ ███░███░║
║██░ ██████░ ██░ ██░ ██████░ ██░███░ ███░ ██░ ██░ ███░ ███████░║
║██░ ██░ ██░ ██████░ ██▀███░ ██░ ██░ ██░ ██░ ██░ ██░ ██░█░██░║
║▀████░ ██░ ██░ ██░ ██░ ██░ ██░ ██████░ ████░ ████░ ██░ ████░ ██░ ██░║
╟────────────────────────────────────────────────────────────────────────────╢
║ This routine will allow you to change an existing Inventory Item ║
║ Number. Option to change the Description, Vendor, and Venditem. ║
║ Will optionally change open invoice detail records. NOT A REPORT. ║
╟─────────────────────────[ SELECT ITEM TO CHANGE ]──────────────────────────╢
║ ║
║ Item: 1245G1-S ║
║ Description #1: A2251245G1 REGISTER ASSEMBLY ║
║ #2: ║
║ Vendor: TTT ║
║ Vendor Item: ║
║ ║
║ Do you wish to update the Invoice Detail Database; Open Invoices? (Y/N) ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Smart Reports, TJS LAB Page: 68
■ CREDIT CARDS & CHECKS
Use this report to list all invoices or receivables that contain a
credit card number or authorization.
╔═[ Credit Cards & Checks ]══════════════════════════╗
║ ║
║ Credit Card & Check Authorization Number Report. ║
║ This reports all invoices in either the Invoice ║
║ or AR Header Databases with Credit Card or Check ║
║ Terms. Reports includes Authorization Number. ║
║ ║
╚════════════════════════════════════════════════════╝
The report can run for a specified date range and directed to printer
or file.
╔════════════════════════════════════════════════════════════════════════════╗
║ █████░ █████░ █████░ █▄██░ ███░ █▄██░ ▄██▄ █▄██░ █████░ ║
║ ██░ ██░ ██ ██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ ██░ ██░ ████ ██░ ████░ ██░ █▀██░ █░ █░ ████░ █░ ║
║ ██░ ██░ ██ ██░ █░█░ █░ █░ █░ █░ █░█░ █░ ║
║ █████░ █████░ █████░ █░██░ ███░ █░ ▀██▀ █░██░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ This report prints out an Invoice Summary of Credit Card and Check ║
║ Invoices for a selected date range. ║
║ ║
║ Select Database -> Invoices (INVOICE.DBF) ║
║ ║
║ Start Date: 04/20/91 End Date: 05/20/91 ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: AUTHORZ.TXT ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO Smart Reports, TJS LAB Page: 69
■ INVENTORY PRICES
This is just a simple list of all your cost and price fields for every
inventory item.
╔═[ Inventory Prices ]═══════════════════════════════╗
║ ║
║ Inventory Prices Reports. This is a list of all ║
║ items with its cost, average cost, average price, ║
║ price, and price1 to price5. ║
║ ║
║ ║
╚════════════════════════════════════════════════════╝
Options include the ability to select from multiple indexes, specify
a date range (for average cost & price), number of lines per page, and
to direct the output to printer or file.
╔═[ Inventory Prices ]═══════════════════════════════╗
║ Select the Index -> ITEM (ITEM) ║
║ Start Date: 05/18/90 End Date: 05/18/91 ║
║ Enter Number of Lines per Page: 55 ║
║ Send Output to Printer? (Y/N) ║
║ Enter File Name: PRICES.TXT ║
║ ║
╚════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 70
■ SALES COMMISSION REPORT
This is a report of all your sales (receivables), indexed by the
sales person. The total of each invoice with the commission of the sales
person is printed. The commission is based on the RATE field found in the
sales person database 'SALESPER.DBF'.
╔═[ Sales Commission Report ]════════════════════════╗
║ ║
║ Sales Commission Report. The commissions are based ║
║ on the sales person's RATE (found in the database ║
║ SALESPER.DBF), applied to the SUBTOTAL of sales ║
║ (AR Header records), for a specific date range. ║
║ ║
╚════════════════════════════════════════════════════╝
The options to select a date range, determine the number of lines per
page and to direct the output to printer or file exist.
╔════════════════════════[ SALES COMMISSION REPORT ]═════════════════════════╗
║ ███ ███ █ ███ ███ ███ ████ █ █ █ █ ███ ███ ███ ███ ████ █ █ ███║
║ █ █ █ █ █ █ █ █ █ ██ ██ ██ ██ █ █ █ █ █ █ ██ █ █ ║
║ ███ █████ █ ██ ███ █ █ █ █████ █████ █ ███ ███ █ █ █ ████ ███║
║ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ ██ █║
║ ███ █ █ ███ ███ ███ ███ ████ █ █ █ █ ███ ███ ███ ███ ████ █ █ ███║
║ ║
║ Start Date: 05/18/90 End Date: 05/18/91 ║
║ ║
║ Enter Number of Lines per Page: 55 ║
║ ║
║ Send Output to Printer? (Y/N) ║
║ ║
║ Enter File Name: COMRPT.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 70.1
■ DAILY 'DOLLAR' (AR RECEIPTS) REPORT
Use this report to print out all AR invoice amounts and Cash Receipts
for a specific day. The options to select a date, determine the number of
lines per page and to direct the output to printer or file exist.
╔══════════════════[ DAILY 'DOLLAR' (AR RECEIPTS) REPORT ]═══════════════════╗
║ █▄███ █ ███ █ █ █ █▄███ ▄███▄ █ █ █ █▄██ ║
║ █ █ █▀█ █ █ █▄ ▄█ █ █ █ █ █ █ █▀█ █ █ ║
║ █ █ █ █ █ █ ███ █ █ █ █ █ █ █ █ ████ ║
║ █ █ █▀▀▀█ █ █ █ █ █ █ █ █ █ █▀▀▀█ █ █ ║
║ █▀███ █ █ ███ ████ █ █▀███ ▀███▀ ████ ████ █ █ █ ██ ║
║ ║
║ Enter Date to Report: 06/13/91 ║
║ Enter Number of Lines per Page: 55 ║
║ Send Output to Printer? (Y/N) ║
║ Enter File Name: DAYDOL.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
■ JEWELRY TAGS - INVENTORY PRICE TAGS
Use this routine to print inventory price tag labels. The following
fields are printed onto the label: ITEM, PRICE, VENDITEM & DESCRIPTION. The
labels form consists of labels 3 across, ie:
│■┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐■│
│■│B-T34242W└──┘BATTERY -│ │B-T34242W└──┘BATTERY -│ │B-T34242 └──┘BATTERY -│■│
│■│ 233.04 DMX-4545X│ │ 233.04 DMX-4545X│ │ 233.04 DMX-4545X│■│
│■│4A-10444 ┌──┐3.6V -LIT│ │4A-10444 ┌──┐3.6V -LIT│ │4A-10444 ┌──┐3.6V -LIT│■│
│■└─────────┘ └─────────┘ └─────────┘ └─────────┘ └─────────┘ └─────────┘■│
╔════════════════════════════════════════════════════════╗
║ This routine prints inventory price tags onto jewelry ║
║ tag labels (3 across). Product: SHARK SKIN 929537 ║
║ Blank tags can be purchased from Jeremiah's & Assoc. ║
║ Tampa, Florida (813) 539-1195 ║
║ ║
║ Set printer to 16.7 Pitch and 8 LPI. ║
║ │■┌──────────┐ ┌──────────┐ ║
║ │■│12TL5242W │ │BATTERY - │ ║
║ │■│ └─────────┘ │ ║
║ │■│ 21.95 TL5242W - │ ║
║ │■│ ┌─────────┐ │ ║
║ │■│LA-108-4 │ │3.6V -LITH│ ║
║ │■└──────────┘ └──────────┘ ║
║ Select ITEM DESC ║
║ Item -> B634643684 SYSGEN - ADAPTER CARD ║
║ B366343414 SYSGEN - ADAPTER CARD#3 ║
║ B346423444 TAPE - CNTRL CARD FOR 342-2333 ║
║ 12TL5242W4 BATTERY - 345242W - 3.4V ║
║ B45435TER1 TAPE BACKUP - CDX 130M W/CNTRL ║
╚════════════════════════════════════════════════════════╝
Esc (Exit) Enter (Print) F5/F6/F7/F8/F9 (Find)
DAYO Smart Reports, TJS LAB Page: 70.2
■ INVOICE DETAIL HISTORY
Use this report as a general purpose report for reporting detail sales
for a specific CUSTOMER, SALES PERSON, CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP,
SHIPPER, TAXCODE or ITEM.
╔═════════════════════════[ INVOICE DETAIL HISTORY ]═════════════════════════╗
║ This report prints out all invoice detail records for a specific ║
║ CUSTOMER, SALES PERSON, CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, ║
║ SHIPPER, TAXCODE or ITEM. This is NOT a Report Form!... ║
║ ║
║ Enter Start Date: 06/16/90 Ending Date: 06/16/91 ║
║ Enter Report Title: ACME PARTS SUPPLY, INC. ║
║ Enter Number of Lines Per Page: 55 ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: HISTORY.TXT ║
║ ║
║ Select Option -> CUSTOMER ║
║ SALES PERSON CODE ║
║ CLASS CODE (ARH.DBF) ║
║ BILL TO STATE ║
║ SHIP TO STATE ║
║ BILL TO ZIP CODE ║
║ SHIP TO ZIP CODE ║
║ SHIPPER CODE ║
║ TAX CODE ║
║ ITEM ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ INVOICE DETAIL HISTORY
The progress of the report is displayed onto the screen, ie:
╔═════════════════════════[ INVOICE DETAIL HISTORY ]═════════════════════════╗
║CUSTOMER = 100 ║
║Item Description Cost Price Qty║
║1245G1 A2251245Ga REGISTER ASSEMBLY 14.000 28.000 1.00║
║1245G2 A2251245Gb REGISTER ASSEMBLY 12.000 24.000 1.00║
║1245G3 A2251245Gc REGISTER ASSEMBLY 12.400 24.490 1.00║
║1245G4 A2251245Ge REGISTER ASSEMBLY 14.240 22.990 1.00║
║10X1TKB516 BRZ 10 X 1 5/16 TEK SCREWS 2.020 6.020 1.00║
║10X1SZ ZINC 10 X 1 SCRULOX SCREWS 0.012 0.030 1.00║
║10X1HXB BRZ 10 X 1 HEX HEAD SCREWS 2.010 4.060 300.00║
║1051232P1 1051232Pa LAMP 0.230 0.550 5.00║
║1051232P2 1051232Pb LAMP 0.420 0.990 1.00║
║1051232P3 1051232Pc LAMP 0.450 0.990 1.00║
║1051232P4 1051232Pd LAMP 0.400 0.850 1.00║
║1051232P5 1051232Pe LAMP 0.400 0.850 1.00║
║10-1 93 FUSE 0.500 1.990 1.00║
║010-0800/S1* SPACE NUT 4.300 9.560 3.00║
║010-0990/25 MARTIAN VASE 2.430 4.490 1.00║
║010-0999/26 JUPITER BROTH 2.420 5.990 1.00║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 70.3
■ EXPANDED DETAIL HISTORY
Use this report to print out all AR Detail records with the following
fields: Item, Description, Cost, Price, Qty, Ship To Name, Class, Salesper,
Shipper, Taxcode, States, & Date. The options include the number of
lines per page and to direct the output to printer or file exist.
╔══════════════[ INVOICE DETAIL HISTORY WITH BILLTO & SHIPTO ]═══════════════╗
║ This report prints out all invoice detail records for a specific ║
║ CUSTOMER, SALES PERSON, CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, ║
║ SHIPPER, TAXCODE or ITEM. This is NOT a Report Form!... ║
║ Report includes expanded information about the customer. ║
║ Enter Start Date: 06/18/90 Ending Date: 06/18/91 ║
║ Enter Report Title: ACME PARTS SUPPLY, INC. ║
║ Enter Number of Lines Per Page: 55 ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: HISTORY2.TXT ║
║ ║
║ Select Option -> CUSTOMER ║
║ SALES PERSON CODE ║
║ CLASS CODE (ARH.DBF) ║
║ BILL TO STATE ║
║ SHIP TO STATE ║
║ BILL TO ZIP CODE ║
║ SHIP TO ZIP CODE ║
║ SHIPPER CODE ║
║ TAX CODE ║
║ ITEM ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO Smart Reports, TJS LAB Page: 71
■ VIEW REPORTS ON SCREEN
This routine was provided to aid the 'fight to stop the cutting down of
trees in the world' by offering you the option to view your reports on your
screen. The only limitation is on the size of the report. No reports can be
viewed if they are over 32,000 bytes. (Just kidding about those trees...)
Due to compiler problems (handling of memory), this routine tends to
'hang' your computer. It is not recommended you use this option if your
machine is performing multitasking programs.
At the first prompt, type and enter the name of the report you wish to
view.
╔══[ View Reports Onscreen ]═════════════════════════════════════════════════╗
║Use this option to view any report written to disk. ║
║Press Enter/Return on an empty prompt to display all files with the ║
║extension of '.TXT'. ║
║File size limited to 32,000 bytes. ║
║ ║
║Enter Report File Name to View On Screen: ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
If the file does not exist, or you press enter on an empty prompt, a
window will appear showing all reports in the current directory. It is
assumed that all reports will have the extension of '.TXT', which is the
DAYO standard.
All reports are displayed in the window, even if they are too large...
╔═══════════════════════════════════════╗
║ File Name Size Date Used ║
╟──────────────┬────────────┬───────────╢
║DAYOERR.TXT │ 1090 │ 06/15/90 ║
║BALANCE.TXT │ 3555 │ 06/15/90 ║
║GL900615.TXT │ 79 │ 06/15/90 ║
║CONFIG.TXT │ 1209 │ 06/15/90 ║
║BUDGETSC.TXT │ 4129 │ 06/15/90 ║
║CLASSRPT.TXT │ 1058 │ 06/02/90 ║
║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐
║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │
║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │
║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │
║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │
║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘
║TRANS1.TXT │ 659 │ 06/15/90 ║
║ASSETS.TXT │ 1300 │ 06/15/90 ║
║LIABIL.TXT │ 1987 │ 06/15/90 ║
║EQUITY.TXT │ 714 │ 06/15/90 ║
╚══════════════╧════════════╧═══════════╝
DAYO Smart Reports, TJS LAB Page: 72
■ REPORT VIEWING SCREEN
The report viewing screen uses the complete screen. The top line
displays the report name. The bottom lines show you the function keys,
all 2 of them. Also displayed at the bottom of the screen is the current
row/column of the cursor position.
DAYORPT View Reports │ File Name: COA.TXT
Page No. 1
07/27/90
INVENTORY ITEM LISTING
Vendor or
Item Mfg Item Description
------------ ------------ ------------------------------
2" GUTTER 2" GUTTER SYSTEM _____________
2ALM518 2" ALMOND COIL _____________
2ALM519 2" ALMOND COIL _____________
2ALM527 2" ALMOND COIL _____________
2ALM533 2" ALMOND COIL _____________
2ANT123 2" ANT IVORY COIL _____________
Esc (Exit) F1 (Help)
DAYO Smart Reports, TJS LAB Page: 73
■ PRINTER DRIVER (SETUP)
This routine was added to preclude you from having to get out of your
seat to change (mess with) the printer to get it to print correctly.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
DAYO Smart Reports, TJS LAB Page: 74
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
1/4
DAYO Smart Reports, TJS LAB Page: 75
■ FULL SCREEN EDIT - F2
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set laser printer to print upright (normal)
LANDSCAPE - Code to set laser printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
DAYO Smart Reports, TJS LAB Page: 76
■ CONFIGURATION
The configurations settings (14 of them), are all accessed from within
the CONFIGURATION menu (first option from the main menu).
╔════════════════════════╗
║ CONFIGURATION ║
╟────────────────────────╢
║ Company Name ║
║ Company Address ║
║ Company Telephone ║
║ Inventory Location ║
║ POS Location ║
║ Customer Location ║
║ AP Location ║
║ Quotes Location ║
║ Back Orders Location ║
║ Price Book Location ║
║ Report Printer Type ║
║ Report Printer Port ║
║ Color ║
║ High Intensity ║
║ ║
╟────────────────────────╢
║ Select Option ║
╚════════════════════════╝
■ CONFIGURATION LISTING
Company Name Quotes Location
Company Address Back Orders Location
Company Telephone Price Book Location
Inventory Location Report Printer Type
POS Location Report Printer Port
Customer Location Color
AP Location High Intensity
Margin Points vs %
DAYO Smart Reports, TJS LAB Page: 77
■ COMPANY NAME, ADDRESS & TELEPHONE
Each field for this option is limited to 30 characters, 14 for the
telephone...
┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐
│ Enter Your Company Name: YOUR COMPANY, INC │
└────────────────────────────────────────────────────────────────────────────┘
┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐
│ Address Line 1: Attn: Accounting │
│ Address Line 2: P.O. BOX 5555 │
│ City, State ZIP: ANYCITY, ST 55555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐
│ Enter Your Company Telephone: 800-555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ INVENTORY LOCATION/DIRECTORY
┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐
│ The location of the DAYO Inventory (INV.DBF) does not have to be in the │
│ same drive/directory as DAYO Reports. If you have installed DAYO Inventory │
│ into a different directory, you need to tell DAYO Reports where to find │
│ the inventory database (INV.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOINV\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOINV\ │
└────────────────────────────────────────────────────────────────────────────┘
■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY
┌────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]────────────┐
│ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be │
│ in the same drive/directory as DAYO Reports. If you have installed the │
│ DAYO POS Databases, into a different directory, you need to tell DAYO │
│ Reports where to find it. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOPOS\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOPOS\ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 78
■ CUSTOMER DATABASE LOCATION/DIRECTORY
┌──────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]──────────────────┐
│ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │
│ in the same drive/directory as DAYO Reports. If you have installed the │
│ DAYO Customer Database (CUSTOMER.DBF), into a different directory, you need│
│ to tell DAYO Reports where to find it. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOAR\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOAR\ │
└────────────────────────────────────────────────────────────────────────────┘
■ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY
┌─────────────[ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY ]──────────────┐
│ The location of the DAYO AP files (ie: APH.DBF) does not have to be │
│ in the same drive/directory as DAYO Reports. If you have installed the │
│ DAYO AP Databases, into a different directory, you need to tell DAYO │
│ Reports where to find them. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOAP\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOAP\ │
└────────────────────────────────────────────────────────────────────────────┘
■ QUOTES DATABASE LOCATION/DIRECTORY
┌───────────────────[ QUOTES DATABASE LOCATION/DIRECTORY ]───────────────────┐
│ The location of the DAYO Quotes Database (QUOTES.DBF) does not have to be │
│ in the same drive/directory as DAYO Reports. If you have installed DAYO │
│ Quotes into a different directory, you need to tell DAYO Reports where to │
│ find the quotes database (QUOTES.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOQUO\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOQUO\ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 79
■ BACKORDERS DATABASE LOCATION/DIRECTORY
┌─────────────────[ BACKORDERS DATABASE LOCATION/DIRECTORY ]─────────────────┐
│ The location of the DAYO BackOrder Database (BO.DBF) does not have to │
│ be in the same drive/directory as DAYO Reports. If you have installed DAYO │
│ BO into a different directory, you need to tell DAYO Reports where to find │
│ the BackOrder database (BO.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOBO\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOBO\ │
└────────────────────────────────────────────────────────────────────────────┘
■ PRICE BOOK DATABASE LOCATION/DIRECTORY
┌─────────────────[ PRICE BOOK DATABASE LOCATION/DIRECTORY ]─────────────────┐
│ The location of the DAYO Price Book Database (PB.DBF) does not have to be │
│ in the same drive/directory as DAYO Reports. If you have installed DAYOPB │
│ into a different directory, you need to tell DAYO Reports where to find │
│ the price book database (PB.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOPB\ │
│ The drive designation is optional (if same as DAYO Reports). │
│ │
│ Enter Location: \DAYOPB\ │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER TYPE
┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐
│ Routine reports are printed according to this selection. │
│ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │
│ The LASER printer type is a Hewlett Packard Laser compatible printer. │
│ Special Laser codes are sent to the LASER option. │
│ │
│ Enter Your Report Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER PORT
┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐
│ Enter Your Report Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 80
■ MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE
┌───────────[ MARGIN - COST PLUS PRICING - POINTS OR PERCENTAGE ]────────────┐
│ You have the option of using a margin/'cost plus' method of pricing │
│ your inventory at time of computing multiple prices. │
│ The default is to compute this margin based on 'points'. │
│ If you wish, you can change this to compute the margin based on a │
│ 'percentage' of cost. │
│ │
│ Do you wish to use the 'Points' method? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR MONITOR
To activate a color change, you must completely exit DAYO Smart Reports,
then reenter.
┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
│ If you have a color monitor and wish to display colors, then select Y, │
│ (YES), else select N (NO) for monochrome and others. │
│ The default is color, low intensity │
│ │
│ Do you have a color monitor? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR INTENSITY
┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
│ Intensity is only applicable with color set to Y. │
│ It will make your colors brighter... │
│ │
│ Set Color Intensity On? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 81
■ MISCELLANEOUS ROUTINES
- The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ MISC ROUTINES MENU:
DAYORPT V3.0, TJS LAB ┌────[April 1990]────┐
╔════════════════════╗ │S M T W T F S │
║ MISC ROUTINES ║═══╗ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟────────────────────╢ ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│
║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│
║ BROWSE DATABASES ║ ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│
║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│
║ CREATE DATABASE ║ ║ ████▀ █░ █░ █░ ▀███▀ │29 30 │
║ DELETE RECORDS ║ ║ │ │
║ ERASE FILE ║ ║ └────────────────────┘
║ EXIT TO DOS ║ ╠═[ Misc Routines ]═════════════════════════════════╗
║ INDEX A DATABASE ║ ║ ║
║ LIST FIELDS ║ ║ Miscellaneous Database Management Routines. ║
║ PACK DATABASE ║ ║ ║
║ MODIFY DATABASE ║ ║ Browse, Edit, Append, Copy, Delete, Pack, ║
║ RECALL RECORDS ║═══╣ Modify, and/or Create Databases. ║
║ RETURN TO MENU ║ ║ ║
║ RUN (DOS COMMAND) ║═══╩═══════════════════════════════════════════════════╝
║ SIMPLE EDITOR ║ █▄█▄ ███░ █▄█▄ ███░ █▄█▄ ▄█▄ █▄█▄ ███░ ▄██▄
║ SORT DATABASE ║ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░
║ TYPE (PRINT) FILE ║ █▄▄█░ █░ █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ █░
║ ZAP DATABASE ║ █▀█░ █░ █▀█░ █░ █░ █░█░ █▀█░ █░ ▀██▄
╟────────────────────╢ █░█▄ █░ █░█▄ █░ █░ █░█░ █░█▄ █░ █░
║ Select Option ║ █░ █░ █░ █░ █░ ███░ █░ ▀█▀ █░ █░ █░ ▀██▀
╚════════════════════╝
DAYO Smart Reports, TJS LAB Page: 82
■ APPEND FROM
- Used to copy records from one database into another database, or to create
records from ASCII files (SDF or DELIMITED).
- The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
- If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 83
- If you are appending from another database (.DBF) then select 'Standard'.
- Select the SDF option if you are appending from a 'flat' ASCII file.
- Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
- If you select a Standard Append, you will then be prompted to enter the name
of the database you wish to get the data from. If you selected the SDF or
DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
- The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENT.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 84
■ BROWSE DATABASES
- Used to edit/view records in a database. Enter the database name you wish to
edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- If there exists an index (.NDX or .NTX), with the same name as the database,
it will be utilized... The DAYO Inventory indexes are the exception. They
are automatically set/used.
- An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO Smart Reports, TJS LAB Page: 85
- To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
- Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
- Remember that there are many more fields to the right of the screen. Press
the right arrow key to view them...
DAYO Smart Reports, TJS LAB Page: 86
■ COPY (.DBF) TO
- Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (EG: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
- The Standard option is simply creating another database (.DBF). The SDF and
DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
DAYO Smart Reports, TJS LAB Page: 87
- The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
- This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 88
- The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
- Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Smart Reports, TJS LAB Page: 89
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Smart Reports, TJS LAB Page: 90
■ DELETE RECORDS
- Delete selected records from databases. The first prompt is for the name of
the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
- After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
- The number of records deleted will be displayed upon the screen as depicted
just above...
DAYO Smart Reports, TJS LAB Page: 91
■ ERASE FILE
- Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
- The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
- This option will close all open files and databases and exit to DOS without
having to return to the main menu exit routine.
DAYO Smart Reports, TJS LAB Page: 92
■ INDEX A DATABASE
- You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
- You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 93
- At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
- List fields to screen or printer. This routine is a great tool for providing
simple reports and lists. The first prompt will be for the database you wish
to work with. Type the name of the file, or press Enter on an empty prompt
to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 94
- The next prompt is for a condition or filter. This makes it possible to list
only specific records that meet that condition you enter. The condition must
be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
- A window box appears next displaying all the fields in the selected database
and an option to list all fields. Highlight any combination of fields ( or
ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 95
- The fields you select will be displayed at center top of screen. Press Esc
to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
- At the next prompt, you can send the list to the SCREEN, PRINTER OR
FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 96
- The list is very simple, and if displayed onto the screen, may look like the
following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
- Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO Smart Reports, TJS LAB Page: 97
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
- Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- After selecting the database, you will be prompted to respond with a Yes or
No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 98
■ RECALL RECORDS
- Recalls records previously marked for deletion. This option is identical to
the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
- Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
- Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
- One useful option is to type and Enter: COMMAND at this prompt. You will be
running another DOS Shell totally out of the program (it still is in memory
though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
- Press and Enter: EXIT to return to your Clipper Application.
EG:
The COMPAQ Personal Computer MS-DOS
Version 3.31
(C) Copyright Compaq Computer Corp. 1982, 1987
(C) Copyright Microsoft Corp. 1981, 1987
C:\KISBBS>EXIT
DAYO Smart Reports, TJS LAB Page: 99
■ SIMPLE EDITOR
- A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
- If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those
changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO Smart Reports, TJS LAB Page: 100
- Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
- This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 101
- The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
- Prints an ASCII/text file to screen or printer. The first prompt is for the
file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 102
- The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
- Totally erase all records in database (forever!). When you
want to remove every record from a database, then use this option. Use with
EXTREME CAUTION! The first prompt is for the file name. Enter the name of
the database you are to 'clean out', or press Enter to select the database
from a window containing all databases in the current directory.
DAYO Smart Reports, TJS LAB Page: 103
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- You will be prompted one last time as to whether you still want to ZAP the
selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanantly) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 104
■ HELP SCREENS
- While in the browse screens, some of the option windows, and in the SIMPLE
EDITOR, pressing the F1 key, will display a help screen.
- BROWSE help:
┌──────────────────────[ DAYORPT HELP: DBEDIT, 0, ]─────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
- Option Box Help:
┌───────────────────────[ DAYORPT HELP: ACHOICE, 0, ]───────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Smart Reports, TJS LAB Page: 105
- Editor help:
┌──────────────────────[ DAYORPT HELP: MEMOEDIT, 0, ]───────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines were added to all DAYO modules.
At almost all prompts and menus you can press F1 for help. Help can be a
function key message as displayed on previous page, a message that you have
created (user defined & inputted), or the ability to read the documentation
on the screen (saves paper).
DAYO Smart Reports, TJS LAB Page: 106
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
┌──────[ DAYO HELP Called by Program: DAYORPT Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish, or ║ │
│ ║ press F1 to view the document for DAYORPT. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ).
DAYO Smart Reports, TJS LAB Page: 107
┌───────[ DAYO HELP Called by Program: DAYORPT Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ONSCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYORPT.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYORPT the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: PAGE: 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO Smart Reports, TJS LAB Page: 108
■ DAYO SMART REPORTS MAINTENANCE & QUIRKS
- If you are on a multiuser network, you must 'flag' (change file attributes)
of all files to make them sharable, readable and writable. Note that the
command/program 'flag' may be called by a different name on your network.
ie:
E:\>FLAG *.NTX SRW
or just to be safe, go ahead and flag all files in the DAYO directory:
E:\>FLAG *.* SRW
- Backups of your data and configuration files should take place daily! You
have no doubt heard many 'scare' stories about losing data. They are all
true! The key files that need to be backed up all have the extension of
.DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files
are notes/memos. The .CFG file(s) contain your configuration information
(as seen in the Configuration module).
- If you are on a network, it is NOT recommended that you use dBase III+ with
the databases. It may write an end of file marker not always recognized by
DAYO. Appending additional records to the database after this point often
leads/creates a 'bad record' in the database.
- If you must use dBase (tm) with DAYO Smart Reports, and you are on a PC base
network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases.
This will allow the opened databases to be shared, and more importantly,
prevent a user (or all users!) from 'crashing'!
- If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then
do not use it... Hope to fix this 'feature' with the next upgrade...
DAYO Smart Reports, TJS LAB Page: 109
■ TJS 'Computer' LAB
TJS LAB produces customized, multiuser software for the PC based network
(ie: Novell and others). Our specialties include Inventory Control, PC
Communications/EDI, Management, Reports (standard and graphic), Data
Conversions, and Accounting (ie: A/R, A/P, G/L).
A unique feature of TJS LAB is that our software is by default, multiuser.
'Standalone' applications are the exception! All our applications are
written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are very reasonably priced!
Custom/contract programming is available. We make program enhancements and
changes very quickly; usually within 24 hours!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Call us for a quote or just for more information!
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858
Or call us, 08:00am to 11:00pm Mon-Sat
Voice Mail between 11:00pm to 08:00am: (407) 291-3960/6987
┌──────────────────────────────────────────────────────────────────────┐
│ Note that TJS LAB will not accept/take any support calls for │
│ UNregistered products! │
└──────────────────────────────────────────────────────────────────────┘
